Re: [PERFORM] About the relation between fragmentation of file and VACUUM

2005-12-01 Thread Bill McGonigle
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

[PERFORM] About the relation between fragmentation of file and VACUUM

2005-11-30 Thread Tatsumi Abe
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