pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feed(no subject)
6+ messages / 4 participants
[nested] [flat]
* (no subject)
@ 2006-08-03 18:33 Jim Nasby <jnasby@pervasive.com>
0 siblings, 2 replies; 6+ messages in thread
From: Jim Nasby @ 2006-08-03 18:33 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re:
@ 2006-08-03 19:15 Steinar H. Gunderson <sgunderson@bigfoot.com>
parent: Jim Nasby <jnasby@pervasive.com>
1 sibling, 1 reply; 6+ messages in thread
From: Steinar H. Gunderson @ 2006-08-03 19:15 UTC (permalink / raw)
To: pgsql-performance
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 */
--
Homepage: http://www.sesse.net/
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re:
@ 2006-08-03 19:29 Chris Hoover <revoohc@gmail.com>
parent: Jim Nasby <jnasby@pervasive.com>
1 sibling, 0 replies; 6+ messages in thread
From: Chris Hoover @ 2006-08-03 19:29 UTC (permalink / raw)
To: Jim Nasby <jnasby@pervasive.com>; +Cc: pgsql-performance
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
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re:
@ 2006-08-03 19:30 Ian Westmacott <ianw@intellivid.com>
parent: Steinar H. Gunderson <sgunderson@bigfoot.com>
0 siblings, 1 reply; 6+ messages in thread
From: Ian Westmacott @ 2006-08-03 19:30 UTC (permalink / raw)
To: Steinar H. Gunderson <sgunderson@bigfoot.com>; +Cc: pgsql-performance
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 */
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re:
@ 2006-08-03 20:31 Chris Hoover <revoohc@gmail.com>
parent: Ian Westmacott <ianw@intellivid.com>
0 siblings, 1 reply; 6+ messages in thread
From: Chris Hoover @ 2006-08-03 20:31 UTC (permalink / raw)
To: Ian Westmacott <ianw@intellivid.com>; +Cc: Steinar H. Gunderson <sgunderson@bigfoot.com>; pgsql-performance
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
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re:
@ 2006-08-03 20:55 Ian Westmacott <ianw@intellivid.com>
parent: Chris Hoover <revoohc@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Ian Westmacott @ 2006-08-03 20:55 UTC (permalink / raw)
To: Chris Hoover <revoohc@gmail.com>; +Cc: 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
>
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2006-08-03 20:55 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-08-03 18:33 Jim Nasby <jnasby@pervasive.com>
2006-08-03 19:15 ` Re: Steinar H. Gunderson <sgunderson@bigfoot.com>
2006-08-03 19:30 ` Re: Ian Westmacott <ianw@intellivid.com>
2006-08-03 20:31 ` Re: Chris Hoover <revoohc@gmail.com>
2006-08-03 20:55 ` Re: Ian Westmacott <ianw@intellivid.com>
2006-08-03 19:29 ` Re: Chris Hoover <revoohc@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox