Re: Excessive growth of pg_attribute and other system tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Excessive growth of pg_attribute and other system tables
Date: 2005-03-17 23:51:24
Message-ID: 28709.1111103484@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

Steve Crawford <scrawford(at)pinpointresearch(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Steve Crawford 2005-03-18 00:37:16 Re: Excessive growth of pg_attribute and other system tables
Previous Message Steve Crawford 2005-03-17 23:47:34 Re: Vacuum full on a big table

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-03-18 00:02:30 Re: corrupted tuple (header?), pg_filedump output
Previous Message Tom Lane 2005-03-17 23:46:04 Re: caches lifetime with SQL vs PL/PGSQL procs