Re: Which gives good performance? separate database vs separate schema - Mailing list pgsql-performance

From Andres Freund
Subject Re: Which gives good performance? separate database vs separate schema
Date
Msg-id 201011251310.17080.andres@anarazel.de
Whole thread Raw
In response to Re: Which gives good performance? separate database vs separate schema  (tv@fuzzy.cz)
Responses Re: Which gives good performance? separate database vs separate schema  (tv@fuzzy.cz)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: tv@fuzzy.cz
Date:
Subject: Re: Which gives good performance? separate database vs separate schema
Next
From: tv@fuzzy.cz
Date:
Subject: Re: Which gives good performance? separate database vs separate schema