Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id B9204B5DC5D for ; Wed, 19 Oct 2011 07:14:21 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 52177-03 for ; Wed, 19 Oct 2011 10:14:15 +0000 (UTC) X-Greylist: delayed 00:27:30.896218 by SQLgrey-1.8.0-rc2 Received: from mail.mastertraining.it (h71-ipv4-93-91-129.mynet.it [93.91.129.71]) by mail.postgresql.org (Postfix) with ESMTP id A0D8AB5DC03 for ; Wed, 19 Oct 2011 07:14:15 -0300 (ADT) Received: from [192.168.1.14] (unknown [192.168.1.14]) by mail.mastertraining.it (Postfix) with ESMTP id DC11DA7057 for ; Wed, 19 Oct 2011 11:46:42 +0200 (CEST) Message-ID: <4E9E9C82.4060400@mastertraining.it> Date: Wed, 19 Oct 2011 11:46:42 +0200 From: "d.davolio@mastertraining.it" User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.23) Gecko/20110922 Thunderbird/3.1.15 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: How many Cluster database on a single server Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.918 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RDNS_DYNAMIC=0.982 X-Spam-Level: X-Archive-Number: 201110/157 X-Sequence-Number: 45379 Hi everybody, I googled a bit around and also checked the mailing lists but I still can't make an idea. We plan to use postgres 9 and the Cluster Database Replica. My colleagues are asking how many Cluster Databases (initdb) can I create and run on a single server. I mean, supposed my server has the resources, can I create 100 or even 200 Cluster Databases? Everyone with the right configuration and in respect of the requisites? Or the postgres architecture doesn't provide similar numbers? We are thinking to use the replica from near 200 databases around the internet on a single db server. Does anyone already did something like this? BTW, this is my first email to postgresql mailing list. If I'm doing something wrong do not hesitate to correct me :) Thanks Davo