pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Adam Ruth <adamruth@mac.com>
To: Subbiah, Stalin <SSubbiah@netopia.com>
Cc: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>
Cc: 'pgsql-performance@postgresql.org' <pgsql-performance@postgresql.org>
Subject: Re: Databases Vs. Schemas
Date: Tue, 23 Mar 2004 20:31:46 -0700
Message-ID: <C75DB9B7-7D43-11D8-A4B4-000A959D1424@mac.com> (raw)
In-Reply-To: <F1F84A2E5F9EBD46A9BDB905EB5B103937C0@mxca1.netopia.com>
References: <F1F84A2E5F9EBD46A9BDB905EB5B103937C0@mxca1.netopia.com>


On Mar 23, 2004, at 11:16 AM, Subbiah, Stalin wrote:

>> And we also created rules to allow update, delete, and insert on those
>> views so that they looked like tables.  The reason we did this is
>> because we ran into issues with too many open files during pg_dump 
>> when
>> we had thousands of tables instead of about 1 hundred tables and
>> thousands of views.
>
> Is it because you had smaller value set for max. allowable number of 
> open
> files descriptor. what was ulimit -a set to ?

It was actually running on OS X and it was a shared memory issue.  We 
would have had to recompile the Darwin kernel to get a bigger SHMMAX, 
but this solution seemed better since we would possibly be installing 
on servers where we wouldn't have that much leeway.  I think that the 
view idea works better for a number of other reasons.  For one, I can 
do a query on the base table and see all of the rows for all of the 
schemas at once, that has proven quite useful.

>
>> We, however, did have a need to periodically select data from 2 
>> schemas
>> at a time, and it was simpler logic than if we needed 2 database
>> connections.
>
> Adam Ruth
>
> On Mar 22, 2004, at 2:30 PM, Subbiah, Stalin wrote:
>
>> --sorry to repost, just subscribed to the list. hopefully it gets to
>> the
>> list this time --
>>
>> Hi All,
>>
>> 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.
>>
>> Thanks,
>> Stalin
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 3: if posting/reading through Usenet, please send an appropriate
>>       subscribe-nomail command to majordomo@postgresql.org so that 
>> your
>>       message can get through to the mailing list cleanly
>>
>




view thread (8+ messages)

Message-ID: <C75DB9B7-7D43-11D8-A4B4-000A959D1424@mac.com>
Permalink:  ../C75DB9B7-7D43-11D8-A4B4-000A959D1424@mac.com/
Also on:    postgresql.org/message-id/C75DB9B7-7D43-11D8-A4B4-000A959D1424@mac.com

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: adamruth@mac.com, SSubbiah@netopia.com, pgsql-performance@postgresql.org
  Subject: Re: Databases Vs. Schemas
  In-Reply-To: <C75DB9B7-7D43-11D8-A4B4-000A959D1424@mac.com>
  References: <F1F84A2E5F9EBD46A9BDB905EB5B103937C0@mxca1.netopia.com> <C75DB9B7-7D43-11D8-A4B4-000A959D1424@mac.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