X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9AA355696E for ; Fri, 18 Mar 2005 15:37:02 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 63619-06 for ; Fri, 18 Mar 2005 15:37:00 +0000 (GMT) Received: from kiss-net.de (3w2.bridge.de [217.160.186.106]) by svr1.postgresql.org (Postfix) with ESMTP id C3A9456962 for ; Fri, 18 Mar 2005 15:36:58 +0000 (GMT) Received: from apollo.kiss-net.de (pD9E5C51A.dip.t-dialin.net [217.229.197.26]) (authenticated (0 bits)) by s15137439.rootmaster.info (8.11.6/8.11.6) with ESMTP id j2IERiN18044 for ; Fri, 18 Mar 2005 15:27:49 +0100 Message-Id: <6.0.1.1.0.20050318145502.00a12e50@mx0.kiss-net.de> X-Sender: u.maiwald@kiss-net.de@mx0.kiss-net.de X-Mailer: QUALCOMM Windows Eudora Version 6.0.1.1 Date: Fri, 18 Mar 2005 15:27:28 +0100 To: pgsql-admin@postgresql.org From: Uwe Maiwald Subject: large database versus many databases Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200503/286 X-Sequence-Number: 16784 Hi, we are currently planning a very large installation of a web-application using PostgreSQL. The application can be configured to handle 1 database per customer, or all customers in one large database. We plan to start with e.g. 500 customers, each of which can have 200 MB or more in the database. And we want the system to be expandable as needed (thousands of customers, using lots of memory). Has anyone any experience what is best - using one very large database for all customers or - using 1 database per customer concerning expandability, performance, server configuration, system updates etc. Is it advisable not to install more than a certain amount of databases on one server? Any hints welcome, Thanks, Uwe