On Mon, Nov 16, 2009 at 12:14 PM, cb <cb@mythtech.net> wrote:
> I've got a pair of servers running PostgreSQL 8.0.4 on Windows. We have
> several tables that add and delete massive amounts of data in a single day
> and are increasingly having a problem with drive fragmentation and it
> appears to be giving us a decent performance hit. This is external
> fragmentation we are dealing with. We already vacuum the tables on a regular
> basis to reduce internal fragmentation as best as possible.
>
> Currently I shut down the PostgreSQL service every few weeks and manually
> run a defragment of the drive, but this is getting tedious. Diskeeper has an
> Automatic Mode that runs in the background all the time to handle this for
> me. They advertise they are compatible with MS SQL server, but don't appear
> to have any specific info on PostgreSQL.
>
> 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'm not sure what the answer is to your actual question, but I'd
highly recommend upgrading to 8.3 or 8.4. The performance is likely
to be a lot better, and 8.0/8.1 are no longer supported on Windows.
...Robert
