Is Diskeeper Automatic Mode safe?

From: cb <cb(at)mythtech(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Is Diskeeper Automatic Mode safe?
Date: 2009-11-16 17:14:44
Message-ID: 55A72FEA-1C9E-4733-9C93-A2BCFA2F7A02@mythtech.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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>

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dave Crooke 2009-11-16 17:44:29 Re: Unexpected sequential scan on an indexed column
Previous Message Wayne Beaver 2009-11-16 17:02:05 Re: Manual vacs 5x faster than autovacs?