From: Arnau <arnaulist@andromeiberica.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: How PostgreSQL handles multiple DDBB instances?
Date: Fri, 25 May 2007 20:16:08 +0200
Message-ID: <465727E8.8090806@andromeiberica.com> (raw)
In-Reply-To: <19775.1180116288@sss.pgh.pa.us>
References: <4656A3BE.1070409@andromeiberica.com>
<8684.1180103080@sss.pgh.pa.us>
<465719D5.9040107@andromeiberica.com>
<19775.1180116288@sss.pgh.pa.us>
Tom Lane wrote:
> 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 ...
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: arnaulist@andromeiberica.com, tgl@sss.pgh.pa.us
Subject: Re: How PostgreSQL handles multiple DDBB instances?
In-Reply-To: <465727E8.8090806@andromeiberica.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox