Table Bloat still there after the Vacuum

From: akp geek <akpgeek(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Table Bloat still there after the Vacuum
Date: 2010-04-26 14:43:03
Message-ID: j2l2024a9fb1004260743n6a9e13eds80448a0abc697e84@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2010-04-26 14:55:35 Re: Table Bloat still there after the Vacuum
Previous Message Bruce Momjian 2010-04-26 14:01:44 Re: Inheritance efficiency