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.
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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend