X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A71735669C for ; Thu, 17 Mar 2005 23:51:52 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 25524-02 for ; Thu, 17 Mar 2005 23:51:44 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 7450756400 for ; Thu, 17 Mar 2005 23:51:42 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j2HNpOlG028710; Thu, 17 Mar 2005 18:51:24 -0500 (EST) To: Steve Crawford Cc: pgsql-admin@postgresql.org Subject: Re: Excessive growth of pg_attribute and other system tables In-reply-to: <200503171515.38214.scrawford@pinpointresearch.com> References: <200503171515.38214.scrawford@pinpointresearch.com> Comments: In-reply-to Steve Crawford message dated "Thu, 17 Mar 2005 15:15:38 -0800" Date: Thu, 17 Mar 2005 18:51:24 -0500 Message-ID: <28709.1111103484@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/280 X-Sequence-Number: 16778 Steve Crawford 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