pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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.



view thread (8+ messages)  latest in thread

Message-ID: <c3p5o0$238c$1@news.hub.org>
Permalink:  ../c3p5o0$238c$1@news.hub.org/
Also on:    postgresql.org/message-id/c3p5o0$238c$1@news.hub.org

 · 

reply

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