Postgres Pro
Downloads
Home   >   mailing lists

Table Bloat still there after the Vacuum - Mailing list pgsql-general

From akp geek
Subject Table Bloat still there after the Vacuum
Date
Msg-id j2l2024a9fb1004260743n6a9e13eds80448a0abc697e84@mail.gmail.com
Whole thread Raw
Responses Re: Table Bloat still there after the Vacuum
Re: Table Bloat still there after the Vacuum
Re: Table Bloat still there after the Vacuum
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Inheritance efficiency
Next
From: Bill Moran
Date:
Subject: Re: Table Bloat still there after the Vacuum