X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 27A8F539FB for ; Thu, 31 Mar 2005 20:04:19 +0100 (BST) 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 46413-08 for ; Thu, 31 Mar 2005 19:04:09 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 014C6539E3 for ; Thu, 31 Mar 2005 20:04:08 +0100 (BST) 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 j2VJ48jd007740; Thu, 31 Mar 2005 14:04:08 -0500 (EST) To: Steve Crawford Cc: "Matthew T. O'Connor" , Jan Wieck , pgsql-hackers@postgreSQL.org Subject: Re: [ADMIN] Excessive growth of pg_attribute and other system tables In-reply-to: <200503310944.50647.scrawford@pinpointresearch.com> References: <200503171515.38214.scrawford@pinpointresearch.com> <423F17D7.7040904@zeut.net> <1219.1111434030@sss.pgh.pa.us> <200503310944.50647.scrawford@pinpointresearch.com> Comments: In-reply-to Steve Crawford message dated "Thu, 31 Mar 2005 09:44:50 -0800" Date: Thu, 31 Mar 2005 14:04:08 -0500 Message-ID: <7739.1112295848@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/1061 X-Sequence-Number: 65863 Steve Crawford writes: > On Monday 21 March 2005 11:40 am, Tom Lane wrote: >> However, given that there are 9334 tuples in 82282 pages, I'd say >> that autovacuum has already failed Steve rather badly :-(. There >> shouldn't be more than a couple hundred pages given that number of >> rows. Perhaps the FSM settings are too small? > Results time. FSM settings were too small but the real problem seems > to be that pg_autovacuum isn't getting the job done. The light just went on ... system catalog updates don't generate statistics reports. Hence, autovacuum doesn't know any work is needed. Should we fix that, or change autovacuum to special-case the system catalogs somehow, or ??? regards, tom lane