Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_class (system) table increasing size. - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: pg_class (system) table increasing size.
Date
Msg-id 20161121174921.fn326sjnlyrlmzvi@alvherre.pgsql
Whole thread Raw
In response to Re: pg_class (system) table increasing size.  (dhaval jaiswal <dhavallj@hotmail.com>)
List pgsql-general
Tree view 
dhaval jaiswal wrote:
> Adding to above.  Below are the outputs.

I just meant that you need to ANALYZE all these system catalogs so that
autovacuum can pick up vacuuming them to remove dead tuples.  Do not
leave autovacuum turned off anymore.

--
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-general by date:

Previous
From: Igor Neyman
Date:
Subject: Re: pg_class (system) table increasing size.
Next
From: Kevin Grittner
Date:
Subject: Re: pg_class (system) table increasing size.