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 09:08:10
Message-ID: 4AFFC4FA.3000007@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

undisclosed user wrote:
> Hello everyone,
>
> I have hit a wall on completing a solution I am working on.
> Originally, the app used a db per user (on MyIsam)....the solution did
> not fair so well in reliability and performance. I have been
> increasingly interested in Postgres lately.
>
> 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.

35000 users with separate databases isn't going to scale well on ANY
conventional system I'm familiar with

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Johan Nel 2009-11-15 11:42:09 Re: Experience with many schemas vs many databases
Previous Message Andreas Kretschmer 2009-11-15 08:34:51 Re: re-using RETURNING