Skip site navigation (1) Skip section navigation (2)

Re: Is Diskeeper Automatic Mode safe?

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Robert Schnabel <schnabelr(at)missouri(dot)edu>
Cc: cb <cb(at)mythtech(dot)net>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Is Diskeeper Automatic Mode safe?
Date: 2009-11-16 19:42:42
Message-ID: 603c8f070911161142j6dd18fb3w4fbb72fa12d01a41@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

Responses

pgsql-performance by date

Next:From: Robert SchnabelDate: 2009-11-16 20:04:46
Subject: Re: Is Diskeeper Automatic Mode safe?
Previous:From: Robert SchnabelDate: 2009-11-16 18:11:24
Subject: Re: Is Diskeeper Automatic Mode safe?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group