X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id F16B79DD768 for ; Fri, 2 Dec 2005 18:59:21 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 71882-05 for ; Fri, 2 Dec 2005 18:59:18 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by postgresql.org (Postfix) with ESMTP id A82989DD718 for ; Fri, 2 Dec 2005 18:59:19 -0400 (AST) Received: from zoraida.natserv.net (p65-147.acedsl.com [66.114.65.147]) by svr2.postgresql.org (Postfix) with ESMTP id 5A2ECF0A1A for ; Fri, 2 Dec 2005 22:59:22 +0000 (GMT) Received: from 35st-server.simplicato.com (static-71-249-233-130.nycmny.east.verizon.net [71.249.233.130]) by zoraida.natserv.net (Postfix) with ESMTP id BD22E7DAB; Fri, 2 Dec 2005 17:59:17 -0500 (EST) References: <11360.1133453022@sss.pgh.pa.us> Message-ID: X-Mailer: http://www.courier-mta.org/cone/ From: Francisco Reyes To: Michael Riess Cc: pgsql-performance@postgresql.org Subject: Re: 15,000 tables Date: Fri, 02 Dec 2005 18:00:53 -0500 Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="US-ASCII" Content-Disposition: inline Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/84 X-Sequence-Number: 15905 Michael Riess writes: > Sorry, I should have included that info in the initial post. You're > right in that most of these tables have a similar structure. But they > are independent and can be customized by the users. > How about creating 50 databases and give each it's own tablespace? It's not only whether PostgreSQL can be optimized, but also how well your filesystem is handling the directory with large number of files. by splitting the directories you will likely help the OS and will be able to perhaps better determine if the OS or the DB is at fault for the slowness.