Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id D960A1337B53 for ; Thu, 25 Nov 2010 08:10:27 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 92223-04 for ; Thu, 25 Nov 2010 12:10:21 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.anarazel.de (mail.anarazel.de [217.115.131.40]) by mail.postgresql.org (Postfix) with ESMTP id A07D9133616B for ; Thu, 25 Nov 2010 08:10:20 -0400 (AST) Received: from alap2.localnet (p579FB159.dip.t-dialin.net [87.159.177.89]) by mail.anarazel.de (Postfix) with ESMTPSA id E8DD9448005; Thu, 25 Nov 2010 13:10:18 +0100 (CET) From: Andres Freund To: pgsql-performance@postgresql.org Subject: Re: Which gives good performance? separate database vs separate schema Date: Thu, 25 Nov 2010 13:10:16 +0100 User-Agent: KMail/1.13.5 (Linux/2.6.36-rc6-andres-00006-g4193d91; KDE/4.5.1; x86_64; ; ) Cc: tv@fuzzy.cz, "Divakar Singh" References: <991565.83793.qm@web65414.mail.ac4.yahoo.com> In-Reply-To: MIME-Version: 1.0 Content-Type: Text/Plain; charset="utf-8" Content-Transfer-Encoding: 7bit Message-Id: <201011251310.17080.andres@anarazel.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201011/372 X-Sequence-Number: 41396 On Thursday 25 November 2010 13:02:08 tv@fuzzy.cz wrote: > I don't think you'll get performance improvement from running two > PostgreSQL clusters (one for DB1, one for DB2). And when running two > databases within the same cluster, there's no measurable performance > difference AFAIK. That one is definitely not true in many circumstances. As soon as you start to hit contention (shared memory, locks) you may very well be better of with two separate clusters. Andres