Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 23A959FB8B5
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Mon,  4 Jun 2007 17:18:46 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 47798-01 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Mon,  4 Jun 2007 17:18:41 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from h07.llord.com (unknown [195.140.142.194])
	by postgresql.org (Postfix) with ESMTP id 7D5759FB361
	for <pgsql-performance@postgresql.org>;
	Mon,  4 Jun 2007 17:18:41 -0300 (ADT)
Received: from par69-8-88-161-102-87.fbx.proxad.net ([88.161.102.87]
	helo=apollo13) by h07.llord.com with esmtpa (Exim 4.66)
	(envelope-from <lists@peufeu.com>)
	id 1HvJ0F-0004eD-Vm; Mon, 04 Jun 2007 22:18:12 +0200
Date: Mon, 04 Jun 2007 22:21:18 +0200
To: "Thomas Andrews" <tandrews@soliantconsulting.com>,
	"Gregory Stark" <stark@enterprisedb.com>
Subject: Re: Thousands of tables versus on table?
From: PFC <lists@peufeu.com>
Cc: "Mark Lewis" <mark.lewis@mir3.com>, pgsql-performance@postgresql.org
Content-Type: text/plain; format=flowed; delsp=yes; charset=utf-8
MIME-Version: 1.0
References: <C289E6F5.A74%tandrews@soliantconsulting.com>
Content-Transfer-Encoding: 7bit
Message-ID: <op.tteytsyycigqcu@apollo13>
In-Reply-To: <C289E6F5.A74%tandrews@soliantconsulting.com>
User-Agent: Opera Mail/9.10 (Linux)
X-PopBeforeSMTPSenders: junk@peufeu.com, lists@peufeu.com, peufeu@peufeu.com,
	pfcaillaud@peufeu.com
X-AntiAbuse: This header was added to track abuse,
	please include it with any abuse report
X-AntiAbuse: Primary Hostname - h07.llord.com
X-AntiAbuse: Original Domain - postgresql.org
X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12]
X-AntiAbuse: Sender Address Domain - peufeu.com
X-Source: 
X-Source-Args: 
X-Source-Dir: 
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=2.446 tagged_above=0 required=5 tests=AWL=-0.330,
	BAYES_50=0.001, RCVD_IN_NJABL_SPAM=2.775
X-Spam-Level: **
X-Archive-Number: 200706/45
X-Sequence-Number: 25078



> can tell you our vacuum every night is taking 2 hours and that disk IO is
> the real killer - the CPU rarely gets higher than 20% or so.

	How many gigabytes of stuff do you have in this database ?
	( du -sh on the *right* directory will suffice, don't include the logs  
etc, aim for data/base/oid)