Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 8C3A29FC244 for ; Fri, 25 May 2007 15:04:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 99988-03 for ; Fri, 25 May 2007 15:04:54 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 8986C9FC224 for ; Fri, 25 May 2007 15:04:53 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l4PI4mi4019776; Fri, 25 May 2007 14:04:48 -0400 (EDT) To: arnaulist@andromeiberica.com cc: PostgreSQL Performance Subject: Re: How PostgreSQL handles multiple DDBB instances? In-reply-to: <465719D5.9040107@andromeiberica.com> References: <4656A3BE.1070409@andromeiberica.com> <8684.1180103080@sss.pgh.pa.us> <465719D5.9040107@andromeiberica.com> Comments: In-reply-to Arnau message dated "Fri, 25 May 2007 19:16:05 +0200" Date: Fri, 25 May 2007 14:04:48 -0400 Message-ID: <19775.1180116288@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/530 X-Sequence-Number: 24920 Arnau writes: >> Can you instead run things with one postmaster per machine and one >> database per customer within that instance? From a performance >> perspective this is likely to work much better. > What I meant is just have only one postmaster per server and a lot of > databases running in it. OK, we are on the same page then. Should work fine. I think I've heard of people running installations with thousands of DBs in them. You'll want to test it a bit of course ... regards, tom lane