From: Bruce Momjian <bruce@momjian.us>
To: Anand Muthukrishnan <lucky.developer@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Postgres schema having > 20,000 schemas
Date: Wed, 24 Jul 2013 10:21:55 -0400
Message-ID: <20130724142155.GD31462@momjian.us> (raw)
In-Reply-To: <D3DD6C1B-5A7B-4432-92D4-690BCB0E6765@gmail.com>
References: <D3DD6C1B-5A7B-4432-92D4-690BCB0E6765@gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
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: bruce@momjian.us, lucky.developer@gmail.com
Subject: Re: Postgres schema having > 20,000 schemas
In-Reply-To: <20130724142155.GD31462@momjian.us>
* 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