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