Re: How PostgreSQL handles multiple DDBB instances?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: arnaulist(at)andromeiberica(dot)com
Cc: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: How PostgreSQL handles multiple DDBB instances?
Date: 2007-05-25 18:04:48
Message-ID: 19775.1180116288@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Arnau <arnaulist(at)andromeiberica(dot)com> writes:
>> Can you instead run things with one postmaster per machine and one
>> database per customer within that instance? From a performance
>> perspective this is likely to work much better.

> What I meant is just have only one postmaster per server and a lot of
> databases running in it.

OK, we are on the same page then. Should work fine. I think I've heard
of people running installations with thousands of DBs in them. You'll
want to test it a bit of course ...

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dave Pirotte 2007-05-25 18:08:52 Performance problem on 8.2.4, but not 8.2.3
Previous Message Gregory Stark 2007-05-25 17:58:13 Re: LIKE search and performance