When do you separate databases?

From: Conrad Schuler <conrad(dot)schuler(at)masks(dot)org>
To: postgreSQL <pgsql-novice(at)postgresql(dot)org>
Subject: When do you separate databases?
Date: 2001-02-07 01:49:25
Message-ID: l03130302b6a657c82b5c@[192.168.0.3]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi All,

I am managing a database design project.

It will database our entire website including:

images, articles, bibliography, ecommerce, membership in website, site
statistics, etc.

The 'lumper' team member says "let's make it all one giant database with
dozens and dozens of tables".

The 'splitter' team member says "let's make it many separate databases each
having fewer tables".

What are the advantages and disadvantages to 'lumping' all tables into one
database vs. 'splitting' into multiple databases with fewer tables?

Thanks,

Conrad

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Stay informed about the latest changes at masks.org,
sign up for the eNewsletter at:
<http://www.masks.org/about/form_mail/newsletter_subscribe.html>

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

masks.org survives on your donations.
Please help by mailing a tax-deductible donation to:

masks.org
P.O. Box 12089
Olympia WA 98508
USA

Our website is at:
<http://www.masks.org/>

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Alfred Perlstein 2001-02-07 02:00:47 Re: When do you separate databases?
Previous Message Tatsuo Ishii 2001-02-07 01:12:58 Re: Re: [NOVICE] Re: Sizing of LARGE databases.