On 11/17/11 4:44 PM, Phoenix Kiula wrote:
I keep getting "FATAL: Sorry, too many clients already" problems.
It's a Quad core machine with dual servers, 4 SCSI disks with RAID 10,
with RAM of 8GB.
Server is Nginx backed by Apache for the php.
Postgresql just has to do about 1000 SELECTs a minute, and about 200
INSERTs a minute. Maybe 10-20 UPDATEs.
My conf file is below. My vmstat + top are below too.
are you using a connection pool? it should be, pgbouncer or something,
the pooling built into php is weak sauce. your php pages should be
grabbing a pool connection, doing their thing, releasing the pool
connection.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general