Re: Is Diskeeper Automatic Mode safe?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Nov 16, 2009 at 12:14 PM, cb <cb@xxxxxxxxxxxx> 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

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux