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 6805DD1DB2B; Mon, 22 Mar 2004 21:00:13 +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 70211-02; Mon, 22 Mar 2004 17:00:22 -0400 (AST) Received: from mxca1.netopia.com (host222.netopia.com [65.206.239.222]) by svr1.postgresql.org (Postfix) with ESMTP id 890DFD1DACB; Mon, 22 Mar 2004 17:00:10 -0400 (AST) Received: by mxca1.netopia.com with Internet Mail Service (5.5.2657.72) id ; Mon, 22 Mar 2004 13:00:22 -0800 Message-ID: From: "Subbiah, Stalin" To: "'pgsql-performance@postgresql.org'" Cc: "'pgsql-admin@postgresql.org'" Subject: Databases Vs. Schemas Date: Mon, 22 Mar 2004 13:00:21 -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/337 X-Sequence-Number: 12906 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