Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id 841E89FB355
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu,  8 Feb 2007 22:04:38 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024)
	with ESMTP id 26907-01 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Thu,  8 Feb 2007 22:04:30 -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 608D29FB312
	for <pgsql-performance@postgresql.org>;
	Thu,  8 Feb 2007 22:04:35 -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 l1924WCD007960;
	Thu, 8 Feb 2007 21:04:32 -0500 (EST)
To: Benjamin Minshall <minshall@intellicon.biz>
cc: pgsql-performance@postgresql.org
Subject: Re: stats collector process high CPU utilization 
In-reply-to: <45CBA443.9090101@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>
Comments: In-reply-to Benjamin Minshall <minshall@intellicon.biz>
	message dated "Thu, 08 Feb 2007 17:29:23 -0500"
Date: Thu, 08 Feb 2007 21:04:32 -0500
Message-ID: <7959.1170986672@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200702/96
X-Sequence-Number: 23150

Benjamin Minshall <minshall@intellicon.biz> writes:
> Tom Lane wrote:
>> How many tables are visible in the pg_stats views?

> There are about 15 databases in the cluster each with around 90 tables. 
>   A count of pg_stats yields between 500 and 800 rows in each database.

Sorry, I was imprecise.  The view "pg_stats" doesn't have anything to do
with the stats collector; what I was interested in was the contents of
the "pg_stat_xxx" and "pg_statio_xxx" views.  It'd be enough to check
pg_stat_all_indexes and pg_stat_all_tables, probably.  Also, do you have
the 8.1 installation still available to get the comparable counts there?

			regards, tom lane