Postgres Pro
Downloads
Home   >   mailing lists

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

From Jeff Davis
Subject Re: How PostgreSQL handles multiple DDBB instances?
Date
Msg-id 1180476453.26915.79.camel@dogma.v10.wvs
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?  (Craig James <craig_james@emolecules.com>)
List pgsql-performance
Tree view 
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 execute the query there?

Have you already considered using views with specific privileges to
separate your customers?

Regards,
    Jeff Davis

pgsql-performance by date:

Previous
From: "Luke Lonergan"
Date:
Subject: Re: setting up raid10 with more than 4 drives
Next
From: "Tyrrill, Ed"
Date:
Subject: Very slow left outer join