On Mon, Nov 16, 2009 at 1:11 PM, Robert Schnabel <schnabelr@xxxxxxxxxxxx> wrote: > cb wrote: >> >> I'm curious if anyone else has used Diskeeper's Automatic Mode in >> combination with PostgreSQL to defrag and keep the drive defragged while >> PostgreSQL is actually running. >> >> Thanks! >> >> -chris >> <www.mythtech.net> >> > > I've been a Diskeeper customer for about 10 years now and consider it 'must > have' software for Windows machines. I do not work for them nor get paid by > them, I just find the software incredibly valuable. I'm running XP-64bit > with 8.4.0 and Diskeeper does a wonderful job of defragmenting the database > tables when they get fragmented. I just checked their website and the 2009 > version is still listed. I've been running the 2010 Enterprise Server > version for about a week and I can tell you that it's great! (I'm actually > running it on 3 servers but only mine has PG) The main difference with the > 2010 version is something that they call IntelliWrite. As everyone knows, > one of the biggest problems with the Windows OS is that it lets > fragmentation occur in the first place. This new IntelliWrite actually > prevents the fragmentation from occurring in the first place (or at least > the vast majority of it). The auto defrag takes care of the rest. I can > attest to this actually working in real life scenarios. The other thing > Diskeeper has is something they call I-FAAST. What this does is monitor > file usage and moves the most heavily accessed files to the fastest part of > the drive. My db is on an Adaptec 52445 with 16 ST373455SS (15K5) in RAID5 > and Diskeeper defrags and moves pretty much everything in \data\base to the > outer part of the drive. So the short answer is yes, I have it running with > PostgreSQL and have not had any problems. Have you unplugged the power cord a few times in the middle of heavy write activity? ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
