Re: How PostgreSQL handles multiple DDBB instances? - Mailing list pgsql-performance

From Tom Lane
Subject Re: How PostgreSQL handles multiple DDBB instances?
Date
Msg-id 19775.1180116288@sss.pgh.pa.us
Whole thread Raw
In response to Re: How PostgreSQL handles multiple DDBB instances?  (Arnau <arnaulist@andromeiberica.com>)
Responses Re: How PostgreSQL handles multiple DDBB instances?  (Arnau <arnaulist@andromeiberica.com>)
List pgsql-performance
Arnau <arnaulist@andromeiberica.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

pgsql-performance by date:

Previous
From: Gregory Stark
Date:
Subject: Re: LIKE search and performance
Next
From: Richard Huxton
Date:
Subject: Re: LIKE search and performance