Re: Which gives good performance? separate database vs separate schema

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Cc: tv(at)fuzzy(dot)cz, "Divakar Singh" <dpsmails(at)yahoo(dot)com>
Subject: Re: Which gives good performance? separate database vs separate schema
Date: 2010-11-25 12:10:16
Message-ID: 201011251310.17080.andres@anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thursday 25 November 2010 13:02:08 tv(at)fuzzy(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message tv 2010-11-25 12:25:33 Re: Which gives good performance? separate database vs separate schema
Previous Message tv 2010-11-25 12:09:06 Re: Which gives good performance? separate database vs separate schema