From: Josh Berkus <josh@agliodbs.com>
To: Subbiah, Stalin <SSubbiah@netopia.com>
To: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>
Cc: 'pgsql-performance@postgresql.org' <pgsql-performance@postgresql.org>
Subject: Re: [PERFORM] Databases Vs. Schemas
Date: Mon, 22 Mar 2004 21:19:50 -0800
Message-ID: <200403222119.50331.josh@agliodbs.com> (raw)
In-Reply-To: <F1F84A2E5F9EBD46A9BDB905EB5B103937B8@mxca1.netopia.com>
References: <F1F84A2E5F9EBD46A9BDB905EB5B103937B8@mxca1.netopia.com>
Stalin,
> We are evaluating the options for having multiple databases vs. schemas on a
> single database cluster for a custom grown app that we developed. Each app
> installs same set of tables for each service. And the service could easily
> be in thousands. so Is it better to have 1000 databases vs 1000 schemas in a
> database cluster. What are the performance overhead of having multiple
> databases vs. schemas (if any). I'm leaning towards having schemas rather
> than databases but i would like to get others opinion on this. Appreciate
> your reply.
No performance difference AFAIK. The real question is whether you have to
have queries joining several "databases". If yes, use Schema; if no, use
databases.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
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-performance@postgresql.org
Cc: josh@agliodbs.com, SSubbiah@netopia.com, pgsql-admin@postgresql.org
Subject: Re: [PERFORM] Databases Vs. Schemas
In-Reply-To: <200403222119.50331.josh@agliodbs.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