Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group