X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AA47FD82C0 for ; Fri, 18 Nov 2005 23:24:08 -0400 (AST) 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 32774-07 for ; Sat, 19 Nov 2005 03:24:12 +0000 (GMT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id 142B3D6D50 for ; Fri, 18 Nov 2005 23:24:06 -0400 (AST) Received: from hotmail.com (bay106-f29.bay106.hotmail.com [65.54.161.39]) by svr2.postgresql.org (Postfix) with ESMTP id E47C1F0B37 for ; Sat, 19 Nov 2005 03:24:10 +0000 (GMT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Fri, 18 Nov 2005 19:24:09 -0800 Message-ID: Received: from 65.54.161.200 by by106fd.bay106.hotmail.msn.com with HTTP; Sat, 19 Nov 2005 03:24:08 GMT X-Originating-IP: [61.230.36.176] X-Originating-Email: [anonpermutation@hotmail.com] X-Sender: anonpermutation@hotmail.com From: "anon permutation" To: pgsql-performance@postgresql.org Subject: What is the max number of database I can create in an instance of pgsql? Date: Sat, 19 Nov 2005 03:24:08 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 19 Nov 2005 03:24:09.0058 (UTC) FILETIME=[B427EC20:01C5ECB8] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.919 required=5 tests=[DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_POST=1.44, MSGID_FROM_MTA_HEADER=0] X-Spam-Score: 1.919 X-Spam-Level: * X-Archive-Number: 200511/389 X-Sequence-Number: 15646 Hi, We want to create a database for each one of our departments, but we only want to have one instance of postgresql running. There are about 10-20 departments. I can easily use createdb to create these databases. However, what is the max number of database I can create before performance goes down? Assuming each database is performing well alone, how would putting 10-20 of them together in one instance affect postgres? In terms of getting a new server for this project, how do I gauge how powerful of a server should I get? Thanks.