On 12/1/05, David Saunders <[EMAIL PROTECTED]> 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 ;)
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
