From: Craig Ringer <ringerc@ringerc.id.au>
To: Radovan Jablonovsky <radovan.jablonovsky@replicon.com>
Cc: Albe Laurenz <laurenz.albe@wien.gv.at>
Cc: pgsql-admin@postgresql.org
Subject: Re: terminating autovacuum process due to administrator command
Date: Mon, 25 Jun 2012 23:32:34 +0800
Message-ID: <4FE88492.6040803@ringerc.id.au> (raw)
In-Reply-To: <CAJYcdTsr++DEra_ttm8yWcKiDHMO7DDO2Lttwp1-e5BN3SmXbg@mail.gmail.com>
References: <CAJYcdTtRanwpiBbgbOAgAXRBoV8J7R0gNim4PxV4h7eyb_sAuw@mail.gmail.com>
<D960CB61B694CF459DCFB4B0128514C208126EEC@exadv11.host.magwien.gv.at>
<CAJYcdTsr++DEra_ttm8yWcKiDHMO7DDO2Lttwp1-e5BN3SmXbg@mail.gmail.com>
On 06/25/2012 11:00 PM, Radovan Jablonovsky wrote:
> Thanks for response,
>
> How were the connections refused (error message)?
> 2012-06-13 13:45:38.809 MDT [25172]: [1-1] FATAL: remaining
> connection slots are reserved for non-replication superuser connections
> 2012-06-13 13:45:38.889 MDT [25173]: [1-1] FATAL: remaining
> connection slots are reserved for non-replication superuser connections
> 2012-06-13 13:45:38.895 MDT [25174]: [1-1] FATAL: remaining
> connection slots are reserved for non-replication superuser connections
>
> Could it be that there are already max_connections
> sessions? max_connection was set to 600, when issue occurred the db
> server had 85 connection and server was under medium load.
I can't explain why it was topping out at 85 when it was set to 600, but
- I strongly recommend that you switch to a connection pool and lower
your max_connections considerably. You'll likely get much better
performance with max connections at 20 or less - the usual rule of thumb
is "num_hdds + num_cpus" but in reality you need to benchmark and tune
to work out what's best.
pgbouncer is a good light-weight pooling option.
--
Craig Ringer
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ringerc@ringerc.id.au, radovan.jablonovsky@replicon.com, laurenz.albe@wien.gv.at
Subject: Re: terminating autovacuum process due to administrator command
In-Reply-To: <4FE88492.6040803@ringerc.id.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox