Skip site navigation (1) Skip section navigation (2)

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] (view raw or whole thread)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group