Re: [PERFORM] How PostgreSQL handles multiple DDBB instances?

On Fri, 2007-05-25 at 20:16 +0200, Arnau wrote: 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

Re: [PERFORM] How PostgreSQL handles multiple DDBB instances?

On Fri, 2007-05-25 at 20:16 +0200, Arnau wrote: 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

[PERFORM] How PostgreSQL handles multiple DDBB instances?

Hi all, I have a doubt/problem about how PostgreSQL handles multiple DDBB instances running on a same server and how I should design the architecture of an application. I have an application that works with multiple customers. Thinking in scalability we are thinking in applying the

Re: [PERFORM] How PostgreSQL handles multiple DDBB instances?

Arnau [EMAIL PROTECTED] writes: I have an application that works with multiple customers. Thinking in scalability we are thinking in applying the following approaches: - Create a separate database instance for each customer. - We think that customer's DB will be quite small, about

Re: [PERFORM] How PostgreSQL handles multiple DDBB instances?

Hi Tom, Arnau [EMAIL PROTECTED] writes: I have an application that works with multiple customers. Thinking in scalability we are thinking in applying the following approaches: - Create a separate database instance for each customer. - We think that customer's DB will be quite

Re: [PERFORM] How PostgreSQL handles multiple DDBB instances?

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

Re: [PERFORM] How PostgreSQL handles multiple DDBB instances?

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

Re: [PERFORM] How PostgreSQL handles multiple DDBB instances?

Arnau [EMAIL PROTECTED] writes: 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