Postgres Pro
Downloads
Home   >   mailing lists

Re: One Large Table or Multiple DBs? - Mailing list pgsql-general

From Gregory Stark
Subject Re: One Large Table or Multiple DBs?
Date
Msg-id 87ps2w650m.fsf@oxford.xeocode.com
Whole thread Raw
In response to One Large Table or Multiple DBs?  (Mike <akiany@gmail.com>)
List pgsql-general
Tree view 
"Mike" <akiany@gmail.com> writes:

> Hi,
>
> What is efficient approach toward storing a web application's user
> data.

I would recommend one large DB with large tables.

You might consider using partitioning to actually store the data separately.
But even then I would not consider it until it was actually a problem.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: order is preserved by outer select?
Next
From: Gregory Stark
Date:
Subject: Re: Force SSL / username combination