Re: Experience with many schemas vs many databases - Mailing list pgsql-general

From John R Pierce
Subject Re: Experience with many schemas vs many databases
Date
Msg-id 4AFFC4FA.3000007@hogranch.com
Whole thread Raw
In response to Experience with many schemas vs many databases  (undisclosed user <lovetodrinkpepsi@gmail.com>)
List 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


pgsql-general by date:

Previous
From: undisclosed user
Date:
Subject: Experience with many schemas vs many databases
Next
From: Jorge Godoy
Date:
Subject: Re: Experience with many schemas vs many databases