Craig Ringer wrote:
On 18/03/2010 9:19 PM, Geoffrey wrote:
We are trying to determine the best solution for a web based
application. We have 13 databases (separate postmaster for each
database) that we need to retrieve data from in order to produce the web
page. This data is changing on a regular basis.
A quick aside: do they really need to be separate databases? Have you
considered using schema within a single database instead? Doing things
that way has both advantages and disadvantages, so whether you want to
do it depends on your needs, but it's worth looking into.
Often, if you're pulling in data from separate databases that can be a
hint that your design is separating things into different DBs that
should perhaps be together in one.
It's been debated ad naseum, but for now, that's the way it is, and it's
not about to change now. ;(
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
