Many little databases or one big one?

From: Jason Hihn <jhihn(at)paytimepayroll(dot)com>
To: Pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Many little databases or one big one?
Date: 2003-05-05 20:04:24
Message-ID: NGBBLHANMLKMHPDGJGAPEEMOCIAA.jhihn@paytimepayroll.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In all likelihood, I will be admin'ing several hundred databases whose
schema is identical. Being the lazy admin that I am, I was thinking that it
may be better for me to combine everything into one large database and just
make views for each former database (after appending a key to each table,
and appropriately naming the view). This would be much more manageable,
since db objects (procedures, triggers, table schemas) would update for all
at once. My developer team is changing things pretty frequently too. To
enforce version consistency through all the databases, this would be the
best and easiest way to do that.

What are the down sides? I know that I can no longer partition the data into
separate directories. A table corruption would effect everyone. More data
needs to be stored (addt'l keys). Are there other downsides? If there are
too many down sides, is there an easier way I can update the db objects (a
tool) for each DB all at once?

Thank you (again!)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott W. Hill 2003-05-06 01:25:48 Importing Data into an Old Version of Postgres
Previous Message Dennis Gearon 2003-05-05 19:31:42 Re: GENERAL: PostgreSQL Inquiry