From: Andres Freund <andres@anarazel.de>
To: pgsql-performance@postgresql.org
Cc: tv@fuzzy.cz, "Divakar Singh" <dpsmails@yahoo.com>
Subject: Re: Which gives good performance? separate database vs separate schema
Date: Thu, 25 Nov 2010 13:10:16 +0100
Message-ID: <201011251310.17080.andres@anarazel.de> (raw)
In-Reply-To: <d0ba0839bcf4b41b456ec741f705e9bb.squirrel@sq.gransy.com>
References: <991565.83793.qm@web65414.mail.ac4.yahoo.com>
<d0ba0839bcf4b41b456ec741f705e9bb.squirrel@sq.gransy.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: andres@anarazel.de, dpsmails@yahoo.com
Subject: Re: Which gives good performance? separate database vs separate schema
In-Reply-To: <201011251310.17080.andres@anarazel.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox