Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group