Have someone experience about high-load web sites, using Postgres/mod_perl-Mason ?
The facts :
* each Apache server has it's database connections (i'm using Mason, which is a
mod_perl "application server")
* the database can be on the same machine, or better, somewhere else
* there may be several Apche machines using a single database
* each connection to the database is a postgres process, using a fair amount of memory
* if I host many sites, the database machine will have many * many database processes
The questions :
* how many database connections can be shared this way, on a typical machine (CPU/RAM)
* is there a way to limit the number of database connections (transaction monitor,
Apache::Session, reverse proxy, etc)
* experience ?
Nicolas Huillard
