From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Huge number of INSERTs |
Date: | 2011-11-18 01:03:49 |
Message-ID: | 4EC5AEF5.2090102@hogranch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | David Morton | 2011-11-18 01:14:49 | Re: upgrading from 8.3 to 9.0 |
Previous Message | Phoenix Kiula | 2011-11-18 00:44:27 | Huge number of INSERTs |