[GENERAL] max_connections

[John D. Burger]

I've recently succeeded in lobbying my sysadmins to upgrade from 7.2.0 
to 7.4.8 (thanks to everyone for the advice on how to leverage this).  
I'm now fiddling with some of the performance parameters, and I'm 
wondering about max_connections.  The default appears to be 100 - this 
is at least an order of magnitude higher than I need.  Would much be 
saved by dropping this down to 10 or less?  I gather I could dial 
shared_buffers up slightly (SHMMAX is 32M on our Solaris boxes), but is 
there any substantive benefit to conservatively setting 
max_connections?

Thanks.
- John D. Burger
  MITRE



---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings