Re: [GENERAL] Server load planning

2005-03-28 Thread Thomas F . O'Connell
Dan, You can get a sense of how much memory you will need by the shorthand presented in table 16-2 for calculating the value of SHMMAX: http://www.postgresql.org/docs/8.0/static/kernel- resources.html#SYSVIPC-PARAMETERS Otherwise, you'll need to include some estimate of work_mem and maintena

[GENERAL] Server load planning

2005-03-27 Thread Dan Sugalski
I'm trying to get a handle on how an app I'm looking to roll out's going to impact the server I'm connecting to, and what sort of capacity planning's going to be needed to make it all work relatively well. I'm looking at around 250-300 simultaneous users, nearly all of them doing interactive w