PGSQL database size question

From: Dan99 <power919(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PGSQL database size question
Date: 2008-03-18 21:57:22
Message-ID: 051e7296-0eba-489e-8a84-464eaf6eb042@s37g2000prg.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am currently brainstorming ideas for a new RIA that I am planing to
make. In the RIA there would be many different sections which do
different things. Some of these sections would require data from
other sections and some sections can sit on there own. Knowing that
this RIA is meant to be easily to distribute and easy to resize,
should the RIA use multiple databases and few tables within each
database, or should there be only one database with lots of tables in
it? I guess my question is, what is the point at which it is more
advantageous to use multiple databases? One of the downfalls of using
multiple databases that I know of, is that it is much harder to
transfer/manipulate data between two tables in two different
databases.

Let me know what you think.

Thanks,
Daniel

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Blair Bethwaite 2008-03-18 22:23:52 Re: Is autovacuum on?
Previous Message Vernon Van Zandt 2008-03-18 21:18:26 Postgres connection error