pgsql-general-owner@postgresql.org wrote on 04/26/2010 03:43:03 PM:
> Hi All - > > I have a table bloated with following details > rows:29431 pages:516039 shouldbe:534 (966.4X) wasted size:4223016960(3 GB) * > > I did a vacuum on the database and also I did > vacuumdb full on the table. Still there is no change. Can you please > suggest if there is any other operation that can be done to take > care of the issue > > Thanks for the help > > Regards
Try a CLUSTER (http://www.postgresql.org/docs/8.4/static/sql-cluster.html) that will physically rewrite the table. However note it will require an Access Exclusive lock on the table preventing any other activity on the table.