X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id A5D209FA250 for ; Mon, 3 Jul 2006 15:37:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 40830-03 for ; Mon, 3 Jul 2006 15:37:27 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from moonunit2.moonview.localnet (wsip-70-167-125-69.sd.sd.cox.net [70.167.125.69]) by postgresql.org (Postfix) with ESMTP id 4987B9FA232 for ; Mon, 3 Jul 2006 15:37:27 -0300 (ADT) Received: from [192.168.0.3] (moonunit3.moonview.localnet [192.168.0.3]) by moonunit2.moonview.localnet (8.13.1/8.13.1) with ESMTP id k63Ipo24030280; Mon, 3 Jul 2006 11:51:50 -0700 Message-ID: <44A9557B.20603@modgraph-usa.com> Date: Mon, 03 Jul 2006 10:35:55 -0700 From: "Craig A. James" User-Agent: Thunderbird 1.5.0.4 (X11/20060516) MIME-Version: 1.0 To: David Gagnon CC: pgsql-performance@postgresql.org Subject: Re: Is postgresql ca do the job for software deployed in References: <20060703170027.37006.qmail@web31809.mail.mud.yahoo.com> In-Reply-To: <20060703170027.37006.qmail@web31809.mail.mud.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/10 X-Sequence-Number: 19870 Richard Broersma Jr wrote: > Each table with-in the database is assigned an OID and is located inside the DB directory. So if > there is a file-system limitation on the number of files with-in a given directory it would also > be a limit to the number of tables that could be created for each database. You could handle this with tablespaces. For example, create ten tablespaces, and then assign customer databases to them in round-robin fashion. This also lets you assign databases to different disks to balance the I/O load. Craig