Re: - Mailing list pgsql-performance

From Ian Westmacott
Subject Re:
Date
Msg-id 1154638537.12111.23.camel@vega.intellivid.com
Whole thread Raw
In response to Re:  ("Chris Hoover" <revoohc@gmail.com>)
List pgsql-performance
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
>


pgsql-performance by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: RAID stripe size question
Next
From: Chris Browne
Date:
Subject: Re: XFS filessystem for Datawarehousing -2