Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 1241E9FB285 for ; Fri, 9 Feb 2007 00:27:11 -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 48770-10 for ; Fri, 9 Feb 2007 00:27:01 -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 E33AB9FB1C4 for ; Fri, 9 Feb 2007 00:27:00 -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 l194QwQe014669; Thu, 8 Feb 2007 23:26:58 -0500 (EST) To: minshall@intellicon.biz cc: pgsql-performance@postgresql.org, Alvaro Herrera Subject: Re: stats collector process high CPU utilization In-reply-to: <62089.75.14.32.120.1170994418.squirrel@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> <20601.1170972476@sss.pgh.pa.us> <45CBA443.9090101@intellicon.biz> <7959.1170986672@sss.pgh.pa.us> <62089.75.14.32.120.1170994418.squirrel@intellicon.biz> Comments: In-reply-to minshall@intellicon.biz message dated "Thu, 08 Feb 2007 23:13:38 -0500" Date: Thu, 08 Feb 2007 23:26:58 -0500 Message-ID: <14668.1170995218@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/98 X-Sequence-Number: 23152 minshall@intellicon.biz writes: > While exploring this problem, I've noticed that one of the frequent insert > processes creates a few temporary tables to do post-processing. Is it > possible that the stats collector is getting bloated with stats from these > short-lived temporary tables? During periods of high activity it could be > creating temporary tables as often as two per second. Hmmm ... that's an interesting point, but offhand I don't see why it'd cause more of a problem in 8.2 than 8.1. Alvaro, any thoughts? regards, tom lane