Re: Experience with many schemas vs many databases

From: John R Pierce <pierce(at)hogranch(dot)com>
To: undisclosed user <lovetodrinkpepsi(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Experience with many schemas vs many databases
Date: 2009-11-15 20:32:39
Message-ID: 4B006567.2040803@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

undisclosed user wrote:
> Currently, I have about 30-35k users/databases. The general table
> layout is the same....only the data is different. I don't need to
> share data across databases. Very similar to a multi-tenant design.

Do these users make their own arbitrary SQL queries? Or is all the
coding canned, and they are simply running applications? in the latter
case, I would definitely suggest using a single database and schema, and
one set of tables and having CustomerID be a field that you index in
these tables.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2009-11-15 20:38:13 Re: Voting: "pg_ctl init" versus "initdb"
Previous Message Scott Marlowe 2009-11-15 19:25:26 Re: Experience with many schemas vs many databases