Thank you all for providing me important details. I will certainly follow them to fix the issue I have
Regards On Mon, Apr 26, 2010 at 11:53 AM, <chris.el...@shropshire.gov.uk> wrote: > > > pgsql-general-ow...@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. > > Chris Ellis > > > ****************************************************************************** > > *If you are not the intended recipient of this email please do not send it > on* > > *to others, open any attachments or file the email locally. * > > *Please inform the sender of the error and then delete the original email. > * > > *For more information, please refer to > http://www.shropshire.gov.uk/privacy.nsf* > > > ****************************************************************************** > > Help prevent the spread of swine flu. CATCH IT. BIN IT. KILL IT. > > > ****************************************************************************** >
