Re: Is Diskeeper Automatic Mode safe?

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Is Diskeeper Automatic Mode safe?
Дата
Msg-id 603c8f070911161009v70d89909r42706e1383c12a5a@mail.gmail.com
обсуждение исходный текст
Ответ на Is Diskeeper Automatic Mode safe?  (cb <cb@mythtech.net>)
Ответы Re: Is Diskeeper Automatic Mode safe?  (cb <cb@mythtech.net>)
Список pgsql-performance
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

В списке pgsql-performance по дате отправления:

Предыдущее
От: cb
Дата:
Сообщение: Is Diskeeper Automatic Mode safe?
Следующее
От: Robert Schnabel
Дата:
Сообщение: Re: Is Diskeeper Automatic Mode safe?