Re: Is Diskeeper Automatic Mode safe?

On Mon, Nov 16, 2009 at 1:11 PM, Robert Schnabel <schnabelr(at)missouri(dot)edu> 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