On Thu, Dec 01, 2005 at 02:50:56PM +0900, Tatsumi Abe wrote:
Could anyone advise some solutions for this fragmentation problem without stopping PostgreSQL ?
Stop doing VACUUM FULL so often. If your table size is constant anyway you're just wasting time by compacting the table and shrinking it, and encouraging fragmentation as each table file grows then shrinks a little bit each day. Mike Stone
