vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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". > 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/ ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings |
| |||
| 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". > > 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 |
| |||
| 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". > > > 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". > 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 > ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings |