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

From: tv(at)fuzzy(dot)cz
To: "Andres Freund" <andres(at)anarazel(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org, 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:25:33
Message-ID: 9e934a9fa3759396caaec2c3974af5d6.squirrel@sq.gransy.com
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
>
Good point, I forgot about that. Anyway it's hard to predict what kind of
performance issue he's facing and whether two clusters would fix it.

regards
Tomas

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ivan Voras 2010-11-25 12:39:42 Re: Performance under contention
Previous Message Andres Freund 2010-11-25 12:10:16 Re: Which gives good performance? separate database vs separate schema