Re:

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(at)pervasive(dot)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(at)pervasive(dot)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
>