On Dec 1, 2005, at 00:50, Tatsumi Abe wrote:
However, In my current environment I can't stop PostgreSQL and cancel
fragmentation.
Could anyone advise some solutions for this fragmentation problem
without stopping PostgreSQL ?
This is somewhat of an aside and intended just as a helpful suggest
Question is about the relation between fragmentation of file and VACUUM
performance.
OS:RedHat Enterprise Linux AS Release 3(Taroon Update 6)
Kernel 2.4.21-37.ELsmp on an i686
Filesystem Type ext3
Filesystem features: has_journal filetype needs_recovery sparse_super
large_file
CPU:I