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 72EFF563D1 for ; Mon, 21 Mar 2005 19:40:42 +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 25591-06 for ; Mon, 21 Mar 2005 19:40:37 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id CF8DF563EA for ; Mon, 21 Mar 2005 19:40:33 +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 j2LJeVlo001224; Mon, 21 Mar 2005 14:40:31 -0500 (EST) To: "Matthew T. O'Connor" Cc: Steve Crawford , pgsql-admin@postgresql.org Subject: Re: Excessive growth of pg_attribute and other system tables In-reply-to: <423F17D7.7040904@zeut.net> References: <200503171515.38214.scrawford@pinpointresearch.com> <200503171536.10389.scrawford@pinpointresearch.com> <423F17D7.7040904@zeut.net> Comments: In-reply-to "Matthew T. O'Connor" message dated "Mon, 21 Mar 2005 13:52:07 -0500" Date: Mon, 21 Mar 2005 14:40:30 -0500 Message-ID: <1219.1111434030@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/331 X-Sequence-Number: 16829 "Matthew T. O'Connor" writes: > I believe this discrepancy has to do with the fact that ANALYZE can > return some very bogus values for reltuples, where as vacuum always > returns an accurate count. I'm not sure how to best handle this. I think 8.0's ANALYZE will do a better estimation job ... at least, Manfred Koizar rewrote the sampling algorithm in hopes of making it more robust. 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? regards, tom lane