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 D1C869FB0D1
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu,  3 Aug 2006 17:57:12 -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 56812-02 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Thu,  3 Aug 2006 20:57:04 +0000 (UTC)
X-Greylist: delayed 01:25:59.629214 by SQLgrey-
Received: from mailhost.intellivid.com (mailhost.intellivid.com
 [64.32.200.11])
	by postgresql.org (Postfix) with ESMTP id 27F8D9FA2A9
	for <pgsql-performance@postgresql.org>;
	Thu,  3 Aug 2006 17:57:01 -0300 (ADT)
Received: from newmail (localhost [127.0.0.1])
	by newmail.intellivid.com (Postfix) with ESMTP id D92A4F18191;
	Thu,  3 Aug 2006 16:57:00 -0400 (EDT)
Received: from vega.intellivid.com (vega.intellivid.com [192.168.2.80])
	by newmail.intellivid.com (Postfix) with ESMTP id 55E30F18191;
	Thu,  3 Aug 2006 16:55:37 -0400 (EDT)
Subject: Re: 
From: Ian Westmacott <ianw@intellivid.com>
To: Chris Hoover <revoohc@gmail.com>
Cc: pgsql-performance@postgresql.org
In-Reply-To: <1d219a6f0608031331p350affeem2773df18abdd2443@mail.gmail.com>
References: <F0D8A119-F876-4AE5-99DD-79A3CC595003@pervasive.com>
	<20060803191522.GA22878@uio.no>
	<1154633440.12111.10.camel@vega.intellivid.com>
	<1d219a6f0608031331p350affeem2773df18abdd2443@mail.gmail.com>
Content-Type: text/plain
Organization: IntelliVid Corp.
Date: Thu, 03 Aug 2006 16:55:37 -0400
Message-Id: <1154638537.12111.23.camel@vega.intellivid.com>
Mime-Version: 1.0
X-Mailer: Evolution 2.6.0 
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=
X-Spam-Level: 
X-Archive-Number: 200608/51
X-Sequence-Number: 20236

No, this is a test server used for regression testing.  Relatively
small (hundreds of GB) and quiet (dozen connections) in the Postgres
universe.

On Thu, 2006-08-03 at 16:31 -0400, Chris Hoover wrote:
> 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
>