From: John McCawley <nospam@hardgeus.com>
To: pgsql-performance@postgresql.org
Subject: Re: What is the max number of database I can create in
Date: Sat, 19 Nov 2005 07:45:10 -0600
Message-ID: <437F2C66.3030603@hardgeus.com> (raw)
In-Reply-To: <EEBF2C76-224F-4AB4-985E-2525A5DAA2EF@myrealbox.com>
References: <BAY106-F29AAEBFDCAA6E044ECFAC6B7510@phx.gbl>
<EEBF2C76-224F-4AB4-985E-2525A5DAA2EF@myrealbox.com>
>> However, what is the max number of database I can create before
>> performance goes down?
>
I know I'm not directly answering your question, but you might want to
consider why you're splitting things up into different logical
databases. If security is a big concern, you can create different
database users that own the different departments' tables, and each of
your apps can login as the corresponding users.
Everyone loves reports. Once you've got data in your database, people
will ask for a billion reports...Whether or not they know it now, most
likely they're going to want reports that cross the department
boundaries (gross revenue, employee listings etc.) and that will be very
difficult if you have multiple databases.
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: nospam@hardgeus.com
Subject: Re: What is the max number of database I can create in
In-Reply-To: <437F2C66.3030603@hardgeus.com>
* 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