From: Elliot <yields.falsehood@gmail.com>
To: Bruce Momjian <bruce@momjian.us>
Cc: Anand Muthukrishnan <lucky.developer@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Postgres schema having > 20,000 schemas
Date: Wed, 24 Jul 2013 13:58:05 -0400
Message-ID: <51F015AD.503@gmail.com> (raw)
In-Reply-To: <20130724142155.GD31462@momjian.us>
References: <D3DD6C1B-5A7B-4432-92D4-690BCB0E6765@gmail.com>
<20130724142155.GD31462@momjian.us>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Also, the "Billion Tables Project" mentions a few attempts at databases
with many tables (20k schemas at 50 tables per schema is one million
tables). The presentation page is here
http://www.pgcon.org/2013/schedule/events/595.en.html
On 2013-07-24 10:21, Bruce Momjian wrote:
> On Wed, Jul 24, 2013 at 04:41:07PM +0530, Anand Muthukrishnan wrote:
>> Can a single Postgres database contain more than 20,000 schemas? What are the
>> implications of such a database design.
>>
>> I was reading about postgres schemas here - http://www.postgresql.org/docs/8.2/
>> static/ddl-schemas.html and I'm planning to create one schema per account in my
>> multi-tenant Ruby on Rails app. Each schema would have a set of tables to store
>> data of the relevant account.
>>
>> Each user/schema for all the features we offer, could have 50-60 tables.
>>
>> Can postgres handle all of this without any hiccups, provided I allocate a
>> large EC2 instance to host the database server ?
>>
>> By experience if any one faced trouble with such number of schemas in postgres,
>> they could share and i thought i can get more guidance to avoid such pitfalls.
> Well, I think the big question is whether you want them all in the same
> database (in separate schemas), or in their own databases. You might
> want to look at this:
>
> http://momjian.us/main/blogs/pgblog/2012.html#April_23_2012
>
> We have done some work in improving performance for databases with many
> table and many schemas. Not sure about the 20k schema performance,
> though. You might need to just test it.
>
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: yields.falsehood@gmail.com, bruce@momjian.us, lucky.developer@gmail.com
Subject: Re: Postgres schema having > 20,000 schemas
In-Reply-To: <51F015AD.503@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox