Experience with many schemas vs many databases

From: undisclosed user <lovetodrinkpepsi(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Experience with many schemas vs many databases
Date: 2009-11-15 06:28:22
Message-ID: 995a16b70911142228k206181ct9516724f91eb13e1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Here are a few questions I have:

1. Could postgres support this many DBs? Are there any weird things that
happen when the postgres is used this way?
2. Is the schema method better? Performance, maintainability, backups,
vacuum? Weird issues?

Any incite is greatly appreciated.

Thanks.
Frank

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2009-11-15 07:30:33 Re: safelly erasing dirs/files
Previous Message Greg Smith 2009-11-15 05:40:56 Re: safelly erasing dirs/files