Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vogrv-0002B2-Ik for pgsql-performance@arkaria.postgresql.org; Thu, 05 Dec 2013 21:53:59 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Vogrv-0003IG-2z for pgsql-performance@arkaria.postgresql.org; Thu, 05 Dec 2013 21:53:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vogru-0003IA-BK for pgsql-performance@postgresql.org; Thu, 05 Dec 2013 21:53:58 +0000 Received: from lists.commandprompt.com ([69.168.55.30]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vogrq-0000T3-Id for pgsql-performance@postgresql.org; Thu, 05 Dec 2013 21:53:58 +0000 Received: from [192.168.1.149] (spinlock.commandprompt.com [69.168.55.30]) by lists.commandprompt.com (Postfix) with ESMTPA id A2B2E32D; Thu, 5 Dec 2013 13:53:52 -0800 (PST) Received: from [192.168.1.149] ([68.186.4.50] helo=[192.168.1.149]) by assp.commandprompt.com with ESMTPS(AES256-SHA) (2.1.1); 5 Dec 2013 13:53:51 -0800 Message-ID: <52A0F5EF.9030305@commandprompt.com> Date: Thu, 05 Dec 2013 13:53:51 -0800 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Thunderbird/24.1.1 MIME-Version: 1.0 To: "Nicholson, Brad (Toronto, ON, CA)" , Max , "pgsql-performance@postgresql.org" Subject: Re: One huge db vs many small dbs References: <1386240130.78000.YahooMailNeo@web163002.mail.bf1.yahoo.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Assp-Version: 2.1.1(11364) on assp.commandprompt.com X-Assp-Client-SSL: yes X-Assp-ID: assp.commandprompt.com m1-80432-05646 X-Assp-Envelope-From: jd@commandprompt.com X-Assp-Intended-For: bnicholson@hp.com X-Assp-Original-Subject: Re: [PERFORM] One huge db vs many small dbs X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org >> One of the many questions we have is about performance of the db if we >> work with only one (using a ClientID to separete de clients info) or thousands >> of separate dbs. The management of the dbs is not a huge concert as we >> have an automated tool. > > If you are planning on using persisted connections, the large number of DB approach is going to have a significant disadvantage. You cannot pool connections between databases. So if you have 2000 databases, you are going to need a minimum of 2000 connections to service those database (assuming you want to keep at least one active connection open per client at a time). That isn't exactly true. You could run multiple poolers. JD > > Brad. > > > -- Command Prompt, Inc. - http://www.commandprompt.com/ 509-416-6579 PostgreSQL Support, Training, Professional Services and Development High Availability, Oracle Conversion, Postgres-XC, @cmdpromptinc For my dreams of your image that blossoms a rose in the deeps of my heart. - W.B. Yeats -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance