From: CoL <col@mportal.hu>
To: pgsql-performance@postgresql.org
Subject: Re: Databases Vs. Schemas
Date: Tue, 23 Mar 2004 12:06:42 +0100
Message-ID: <c3p5o0$238c$1@news.hub.org> (raw)
In-Reply-To: <200403222119.50331.josh@agliodbs.com>
References: <F1F84A2E5F9EBD46A9BDB905EB5B103937B8@mxca1.netopia.com>
<200403222119.50331.josh@agliodbs.com>
hi
Josh Berkus wrote:
> 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.
don't forget the pg_hba.conf :) You need 1000 declaration. Was a thread
before, title: performance problem - 10.000 databases
Check this:
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=1068039213.28814.116.camel%40...
C.
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: col@mportal.hu
Subject: Re: Databases Vs. Schemas
In-Reply-To: <c3p5o0$238c$1@news.hub.org>
* 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