Re: Excessive growth of pg_attribute and other system tables - Mailing list pgsql-admin

From Tom Lane
Subject Re: Excessive growth of pg_attribute and other system tables
Date
Msg-id 28709.1111103484@sss.pgh.pa.us
Whole thread Raw
In response to Excessive growth of pg_attribute and other system tables  (Steve Crawford <scrawford@pinpointresearch.com>)
Responses Re: Excessive growth of pg_attribute and other system tables  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-admin
Steve Crawford <scrawford@pinpointresearch.com> writes:
> My autovacuum config is running and I do see regular periodic vacuums
> of these pg_ tables but still they grow.

Do you have the FSM settings set large enough to account for all the
free space?

Also you might want to check for newer versions of autovacuum.  I recall
that the earlier releases had bugs that sometimes made it skip vacuuming
tables that should be vacuumed.

            regards, tom lane

pgsql-admin by date:

Previous
From: Steve Crawford
Date:
Subject: Re: Vacuum full on a big table
Next
From: Steve Crawford
Date:
Subject: Re: Excessive growth of pg_attribute and other system tables