From: Tom Lane <tgl@sss.pgh.pa.us>
To: arnaulist@andromeiberica.com
Cc: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: How PostgreSQL handles multiple DDBB instances?
Date: Fri, 25 May 2007 14:34:24 -0400
Message-ID: <20203.1180118064@sss.pgh.pa.us> (raw)
In-Reply-To: <465727E8.8090806@andromeiberica.com>
References: <4656A3BE.1070409@andromeiberica.com>
<8684.1180103080@sss.pgh.pa.us>
<465719D5.9040107@andromeiberica.com>
<19775.1180116288@sss.pgh.pa.us>
<465727E8.8090806@andromeiberica.com>
Arnau <arnaulist@andromeiberica.com> 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 there?
[ shrug... ] That's going to depend on enough factors that I don't
think anyone could give you a generic answer. You'd have to test it for
yourself under your own application conditions.
However: doing it that way seems to me to create severe risks that the
customers might be able to look at each others' data. You probably want
to go with separate databases just as a security matter.
regards, tom lane
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: tgl@sss.pgh.pa.us, arnaulist@andromeiberica.com
Subject: Re: How PostgreSQL handles multiple DDBB instances?
In-Reply-To: <20203.1180118064@sss.pgh.pa.us>
* 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