X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 5CCAC9FB24D for ; Thu, 3 Aug 2006 16:29:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 60365-07 for ; Thu, 3 Aug 2006 16:29:44 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0102.google.com (wx-out-0102.google.com [66.249.82.192]) by postgresql.org (Postfix) with ESMTP id 2E4349FB205 for ; Thu, 3 Aug 2006 16:29:43 -0300 (ADT) Received: by wx-out-0102.google.com with SMTP id t13so1139933wxc for ; Thu, 03 Aug 2006 12:29:43 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=IDxmn8OJX09k7wkrXD8UZdBp53czDIWSa3DzBnusUB9p52eiZv+8jbUoi57t0Q11+EM/YLPftqJOZ0O7SnQ8kuviN0EOGhlyu8EDDDLmwITXB7j5azD9rCjcogEWPozn44jdSt/xEx9wS1opb/KbxyLxWoVnGVfISJxV494HlwA= Received: by 10.70.32.10 with SMTP id f10mr3682228wxf; Thu, 03 Aug 2006 12:29:43 -0700 (PDT) Received: by 10.70.73.6 with HTTP; Thu, 3 Aug 2006 12:29:42 -0700 (PDT) Message-ID: <1d219a6f0608031229r15868fb4p37ba030c591a25e1@mail.gmail.com> Date: Thu, 3 Aug 2006 15:29:42 -0400 From: "Chris Hoover" To: "Jim Nasby" Subject: Re: Cc: "PGSQL Performance" In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_83725_23926613.1154633382954" References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.994 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_30_40, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/45 X-Sequence-Number: 20230 ------=_Part_83725_23926613.1154633382954 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline I've got 226 customer databases in one cluster. Works like a champ with 8.1.3. I have 3 additional PostgreSQL servers with our largest customers on them. They have between 10 and 30 databases. The smallest of my servers has 261GB's worth of db's in the cluster, and the largest is 400GB's. BTW, our application is an asp application also. Just some fun numbers for you. Chris P.S. Thanks to all of the PostgreSQL developers for the great work and for providing the awesome support. On 8/3/06, Jim Nasby wrote: > > I'm at a client who's an ASP; they've written their app such that each > customer gets their own database. Rigth now they're at nearly 200 > databases, and were thinking that they "must be the largest PostgreSQL > install in the world". :) After taking them down a notch or two, I > started wondering how many sites could beat 200 databases in a single > cluster. I'm sure there's any number that can, though 200 databases in a > cluster certainly isn't mainstream. > -- > Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com > Pervasive Software http://pervasive.com work: 512-231-6117 > vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > ------=_Part_83725_23926613.1154633382954 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I've got 226 customer databases in one cluster.  Works like a champ with 8.1.3.  I have 3 additional PostgreSQL servers with our largest customers on them.  They have between 10 and 30 databases.  The smallest of my servers has 261GB's worth of db's in the cluster, and the largest is 400GB's.

BTW, our application is an asp application also.

Just some fun numbers for you.

Chris

P.S.

Thanks to all of the PostgreSQL developers for the great work and for providing the awesome support.

On 8/3/06, Jim Nasby <jnasby@pervasive.com> wrote:
I'm at a client who's an ASP; they've written their app such that each
customer gets their own database. Rigth now they're at nearly 200
databases, and were thinking that they "must be the largest PostgreSQL
install in the world". :) After taking them down a notch or two, I
started wondering how many sites could beat 200 databases in a single
cluster. I'm sure there's any number that can, though 200 databases in a
cluster certainly isn't mainstream.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com     work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461




---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

------=_Part_83725_23926613.1154633382954--