Re: How PostgreSQL handles multiple DDBB instances?

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: arnaulist(at)andromeiberica(dot)com
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: How PostgreSQL handles multiple DDBB instances?
Date: 2007-05-29 22:07:33
Message-ID: 1180476453.26915.79.camel@dogma.v10.wvs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tyrrill, Ed 2007-05-30 00:16:57 Very slow left outer join
Previous Message Luke Lonergan 2007-05-29 21:50:57 Re: setting up raid10 with more than 4 drives