Re: Huge number of INSERTs

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