Thread: Disk Keeper

Hi,

Has any body got any experience of using Disk Keeper on Windows (On line
defragmenter) on the same machine as a PostgreSQL server. We are proposing
to use it but do not know if it will have any adverse effects on the overall
performance of the Postgres Server. If anybody is already using this or any
other defragmentation tool can you let me know.

Many Thanks in advance

On 12/1/05, David Saunders <dsaunders99@hotmail.com> wrote:
> Hi,
>
> Has any body got any experience of using Disk Keeper on Windows (On line
> defragmenter) on the same machine as a PostgreSQL server. We are proposing
> to use it but do not know if it will have any adverse effects on the overall
> performance of the Postgres Server. If anybody is already using this or any
> other defragmentation tool can you let me know.
>
> Many Thanks in advance
>

i don't think this is a good idea... in windows autovacuum is enable
by default (IIRC) and i think will be a conflict if your
defragmentation tool try to work just when autovacuum decides to work
too...

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

If you feel the need to defragment your database files you need to set them up differently. Using partitions on your hard disks and smart use of tablespaces you can create a setup that needs no defragmenting.

Besides, on larger disks defragmentation isn't even necessary.