X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 24D84D1EC57; Tue, 23 Mar 2004 18:17:03 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 01690-08; Tue, 23 Mar 2004 14:17:02 -0400 (AST) Received: from mxca1.netopia.com (host222.netopia.com [65.206.239.222]) by svr1.postgresql.org (Postfix) with ESMTP id 4918ED1CC93; Tue, 23 Mar 2004 14:17:00 -0400 (AST) Received: by mxca1.netopia.com with Internet Mail Service (5.5.2657.72) id ; Tue, 23 Mar 2004 10:16:59 -0800 Message-ID: From: "Subbiah, Stalin" To: 'Adam Ruth' , "Subbiah, Stalin" Cc: "'pgsql-admin@postgresql.org'" , "'pgsql-performance@postgresql.org'" Subject: Re: Databases Vs. Schemas Date: Tue, 23 Mar 2004 10:16:52 -0800 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: text/plain; charset="ISO-8859-1" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/303 X-Sequence-Number: 12872 >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 ? >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 >