Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 33DE79FB323 for ; Thu, 8 Feb 2007 18:08:01 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 62669-01 for ; Thu, 8 Feb 2007 18:07:58 -0400 (AST) 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 0F2169FB324 for ; Thu, 8 Feb 2007 18:07: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 l18M7uqi020602; Thu, 8 Feb 2007 17:07:56 -0500 (EST) To: Benjamin Minshall cc: pgsql-performance@postgresql.org Subject: Re: stats collector process high CPU utilization In-reply-to: <45CB9C4D.30902@intellicon.biz> References: <45CB5441.1040707@intellicon.biz> <21013.1170955076@sss.pgh.pa.us> <45CB5D06.7090004@intellicon.biz> <7994.1170960391@sss.pgh.pa.us> <45CB9330.3000603@intellicon.biz> <19935.1170969862@sss.pgh.pa.us> <45CB9C4D.30902@intellicon.biz> Comments: In-reply-to Benjamin Minshall message dated "Thu, 08 Feb 2007 16:55:25 -0500" Date: Thu, 08 Feb 2007 17:07:56 -0500 Message-ID: <20601.1170972476@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/94 X-Sequence-Number: 23148 Benjamin Minshall writes: > Seems the problem may be related to a huge global/pgstat.stat file. > Under 8.1.5 it was about 1 MB; now it's 90 MB in 8.2.3. Yoi. We didn't do anything that would bloat that file if it were storing the same information as before. What I'm betting is that it's storing info on a whole lot more tables than before. Did you decide to start running autovacuum when you updated to 8.2? How many tables are visible in the pg_stats views? regards, tom lane