Tom Lane wrote:
Arnau <[EMAIL PROTECTED]> 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 ...
I'm worried about performance, I have done some tests and I have on a
server more than 400 DBs, so it's possible to run such amount of DBs in
a single postmaster.
The point I'm worried is performance. Do you think the performance
would be better executing exactly the same queries only adding an extra
column to all the tables e.g. customer_id, than open a connection to the
only one customers DB and execute the query there?
I don't know if PostgreSQL cache's mechanism works as good as
querying to 400 possible DBs or just to one possible DB.
Thank you very much for your help :)
--
Arnau
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
