X-Original-To: pgsql-performance-postgresql.org@postgresql.org
Received: from localhost (wm.hub.org [200.46.204.128])
	by postgresql.org (Postfix) with ESMTP id D7F1F9FA2A7
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu,  3 Aug 2006 17:31:33 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024)
	with ESMTP id 49213-04 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Thu,  3 Aug 2006 20:31:26 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from wx-out-0102.google.com (wx-out-0102.google.com [66.249.82.198])
	by postgresql.org (Postfix) with ESMTP id E526A9FB2AA
	for <pgsql-performance@postgresql.org>;
	Thu,  3 Aug 2006 17:31:25 -0300 (ADT)
Received: by wx-out-0102.google.com with SMTP id t13so1157762wxc
	for <pgsql-performance@postgresql.org>;
	Thu, 03 Aug 2006 13:31:25 -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=DyA3j0JJr2a9X5uicK9y+yreBAegzxA7dw9aN9we2aMJkU1v1sFErwyaHFYRVvgAdsGOZsaUKYEI/t9gQlFfzkCbIHM11xxn9GUGFEfigCovxhTNib1Crvrfu79cL7NptmqEtkykhKNFbMB2xwlVEto3vEN1DzLlKb1i+EzQx28=
Received: by 10.70.89.1 with SMTP id m1mr3733557wxb;
	Thu, 03 Aug 2006 13:31:25 -0700 (PDT)
Received: by 10.70.73.6 with HTTP; Thu, 3 Aug 2006 13:31:24 -0700 (PDT)
Message-ID: <1d219a6f0608031331p350affeem2773df18abdd2443@mail.gmail.com>
Date: Thu, 3 Aug 2006 16:31:24 -0400
From: "Chris Hoover" <revoohc@gmail.com>
To: "Ian Westmacott" <ianw@intellivid.com>
Subject: Re: 
Cc: "Steinar H. Gunderson" <sgunderson@bigfoot.com>,
	pgsql-performance@postgresql.org
In-Reply-To: <1154633440.12111.10.camel@vega.intellivid.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_84872_18009305.1154637084920"
References: <F0D8A119-F876-4AE5-99DD-79A3CC595003@pervasive.com>
	<20060803191522.GA22878@uio.no>
	<1154633440.12111.10.camel@vega.intellivid.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.574 tagged_above=0 required=5
	tests=DNS_FROM_RFC_ABUSE, HTML_30_40, HTML_MESSAGE, SPF_PASS
X-Spam-Level: 
X-Archive-Number: 200608/49
X-Sequence-Number: 20234

------=_Part_84872_18009305.1154637084920
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Just curious, is this a production server?  Also, how large is the total
cluster on disk?

On 8/3/06, Ian Westmacott <ianw@intellivid.com> wrote:
>
> is that all?
>
> psql -l | grep 'rows)'
> (2016 rows)
>
> On Thu, 2006-08-03 at 21:15 +0200, Steinar H. Gunderson wrote:
> > On Thu, Aug 03, 2006 at 01:33:35PM -0500, 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.
> >
> > cassarossa:~> psql -h sql -l | grep 'rows)'
> > (137 rows)
> >
> > That's our measly student society. :-)
> >
> > /* Steinar */
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

------=_Part_84872_18009305.1154637084920
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Just curious, is this a production server?&nbsp; Also, how large is the total cluster on disk?<br><br><div><span class="gmail_quote">On 8/3/06, <b class="gmail_sendername">Ian Westmacott</b> &lt;<a href="mailto:ianw@intellivid.com">
ianw@intellivid.com</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">is that all?<br><br> psql -l | grep 'rows)'<br>(2016 rows)
<br><br>On Thu, 2006-08-03 at 21:15 +0200, Steinar H. Gunderson wrote:<br>&gt; On Thu, Aug 03, 2006 at 01:33:35PM -0500, Jim Nasby wrote:<br>&gt; &gt; I'm at a client who's an ASP; they've written their app such that each
<br>&gt; &gt; customer gets their own database. Rigth now they're at nearly 200<br>&gt; &gt; databases, and were thinking that they &quot;must be the largest PostgreSQL<br>&gt; &gt; install in the world&quot;. :) After taking them down a notch or two, I
<br>&gt; &gt; started wondering how many sites could beat 200 databases in a single<br>&gt; &gt; cluster. I'm sure there's any number that can, though 200 databases in a<br>&gt; &gt; cluster certainly isn't mainstream.<br>
&gt;<br>&gt; cassarossa:~&gt; psql -h sql -l | grep 'rows)'<br>&gt; (137 rows)<br>&gt;<br>&gt; That's our measly student society. :-)<br>&gt;<br>&gt; /* Steinar */<br><br><br>---------------------------(end of broadcast)---------------------------
<br>TIP 4: Have you searched our list archives?<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="http://archives.postgresql.org">http://archives.postgresql.org</a><br></blockquote></div><br>

------=_Part_84872_18009305.1154637084920--