Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id D0E429FA250; Thu, 11 Jan 2007 18:27:02 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 99290-03; Thu, 11 Jan 2007 18:26:53 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 7A1E19FA249; Thu, 11 Jan 2007 18:26:57 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l0BMQtlE006872; Thu, 11 Jan 2007 17:26:55 -0500 (EST) To: Kim cc: pgsql-performance@postgresql.org, pgsql-hackers@postgresql.org Subject: Re: unusual performance for vac following 8.2 upgrade In-reply-to: <28949.1168544710@sss.pgh.pa.us> References: <45A671CD.1050706@myemma.com> <27939.1168539652@sss.pgh.pa.us> <45A68C74.4080405@myemma.com> <28949.1168544710@sss.pgh.pa.us> Comments: In-reply-to Tom Lane message dated "Thu, 11 Jan 2007 14:45:10 -0500" Date: Thu, 11 Jan 2007 17:26:55 -0500 Message-ID: <6871.1168554415@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/190 X-Sequence-Number: 22791 I wrote: > (2) Reconsider whether last-vacuum-time should be sent to the collector > unconditionally. Actually, now that I look, the collector already contains this logic: /* * Don't create either the database or table entry if it doesn't already * exist. This avoids bloating the stats with entries for stuff that is * only touched by vacuum and not by live operations. */ and ditto for analyze messages. So my idea that the addition of last-vac-time was causing an increase in the statistics file size compared to 8.1 seems wrong. How large is your $PGDATA/global/pgstat.stat file, anyway? regards, tom lane