> > > The database article at Zend mentioned a replication server for
> > > PostgreSQL., available at www.pgsql.com. The press release says the
code
> > > itself has been put into the CVS tree, but I can't find any
documentation
> > > on it anywhere.
>
> The article at Zend also stated that PostgreSQL could handle 1000
> transactions a second with 100 users. This is funny, since my postgresql
> server (7.1.2) running on a PII 533 with SCSI and 256 mb RAM (HP Server)
> can't even handle 1000 select statements per second. Not even close.
"transactions per second" does not equate to "real-world queries per
second". : )
When we were sizing out a machine, a Compaq rep came in and asked how
many queries we did in a day, and he told us that a single CPU alpha could
handle about ten times that many "transactions per second". The machine
we have now is a lot faster than a single Alpha, and is getting
overloaded.
steve