Re: [PERFORM] Databases Vs. Schemas - Mailing list pgsql-admin

From Josh Berkus
Subject Re: [PERFORM] Databases Vs. Schemas
Date
Msg-id 200403222119.50331.josh@agliodbs.com
Whole thread Raw
In response to Databases Vs. Schemas  ("Subbiah, Stalin" <SSubbiah@netopia.com>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Hemapriya
Date:
Subject: Torn pages Detection in SQL SERVER
Next
From: alvaro@audifarma.com.co
Date:
Subject: Re: SOS ---- Could you help me with postgresql.....????