Thread:
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
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/
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.
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
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 */
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
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 >