On 1/22/2010 2:27 PM, Richard Neill wrote:
DM wrote:
Is there any script/tool to identify if the table requires full
vacuum? or to re-index an existing index table?
http://pgsql.tapoueh.org/site/html/news/20080131.bloat.html
The bucardo project has released its nagios plugins for PostgreSQL a
DM wrote:
Is there any script/tool to identify if the table requires full vacuum?
or to re-index an existing index table?
Don't know if there is a script to specifically do this, though you may
find this query a useful one:
SELECT relname, reltuples, relpages FROM pg_class ORDER BY relpage
Is there any script/tool to identify if the table requires full vacuum? or
to re-index an existing index table?
Thanks
Deepak
On Fri, Jan 22, 2010 at 12:11 AM, DM wrote:
> Hello All,
>
> How to identify if a table requires full vacuum? How to identify when to do
> re-index on an existing index
