X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 397ADDBC24 for ; Sat, 19 Nov 2005 09:45:09 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 27656-02 for ; Sat, 19 Nov 2005 13:45:11 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id A1BEEDB7FA for ; Sat, 19 Nov 2005 09:45:06 -0400 (AST) Received: from worleyco.com (unknown [70.158.54.226]) by svr2.postgresql.org (Postfix) with ESMTP id 7D97CF0B2C for ; Sat, 19 Nov 2005 13:45:10 +0000 (GMT) Received: from [192.168.4.32] (unknown [192.168.4.32]) by worleyco.com (Postfix) with ESMTP id 73B5E12E718 for ; Sat, 19 Nov 2005 07:45:09 -0600 (CST) Message-ID: <437F2C66.3030603@hardgeus.com> Date: Sat, 19 Nov 2005 07:45:10 -0600 From: John McCawley User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: What is the max number of database I can create in References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[AWL=0.000] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/398 X-Sequence-Number: 15655 >> However, what is the max number of database I can create before >> performance goes down? > I know I'm not directly answering your question, but you might want to consider why you're splitting things up into different logical databases. If security is a big concern, you can create different database users that own the different departments' tables, and each of your apps can login as the corresponding users. Everyone loves reports. Once you've got data in your database, people will ask for a billion reports...Whether or not they know it now, most likely they're going to want reports that cross the department boundaries (gross revenue, employee listings etc.) and that will be very difficult if you have multiple databases.