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 1D9BB53A4F for ; Thu, 31 Mar 2005 21:06:23 +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 58229-09 for ; Thu, 31 Mar 2005 20:06:13 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 4EA85534F6 for ; Thu, 31 Mar 2005 21:06:12 +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 j2VK6DlM014687; Thu, 31 Mar 2005 15:06:13 -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: <7739.1112295848@sss.pgh.pa.us> References: <200503171515.38214.scrawford@pinpointresearch.com> <423F17D7.7040904@zeut.net> <1219.1111434030@sss.pgh.pa.us> <200503310944.50647.scrawford@pinpointresearch.com> <7739.1112295848@sss.pgh.pa.us> Comments: In-reply-to Tom Lane message dated "Thu, 31 Mar 2005 14:04:08 -0500" Date: Thu, 31 Mar 2005 15:06:13 -0500 Message-ID: <14686.1112299573@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/1064 X-Sequence-Number: 65866 I wrote: > The light just went on ... system catalog updates don't generate > statistics reports. Hence, autovacuum doesn't know any work is needed. The above claim is too strong --- they do normally generate stats updates. However, in a simple test I observed that pg_stat_all_tables.n_tup_del did not seem to increment for the deletes that occur when a temp table is dropped during backend exit. (Most likely we aren't flushing out the final stats messages...) Steve, is your app in the habit of creating lots of temp tables that are not dropped explicitly? That would explain why you are getting bit more than other people. regards, tom lane