Search Postgresql Archives

Re: max_connections reached in postgres 9.3.3

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Jun 12, 2014 at 3:32 PM, Kevin Grittner <kgrittn@xxxxxxxxx> wrote:
> Merlin Moncure <mmoncure@xxxxxxxxx> wrote:
>
>> or something else entirely.
>
>
> It strikes me that this might be relevant:

Agreed.  The stock advice to many, many problems of this sort is 'use
pgbouncer' but it can be hard to work in a lot of code bases and we
have to be careful to rule out some underlying possible contributing
factors before switching up things up to much.  THP compaction in
particular has plaguing servers throughout the company I work for; we
haven't figured out OP's system went loaded all of a sudden.
Nevertheless, having a setup that can accumulate 1000's of connections
during high load events is not the way to go.  Other than pgbouncer,
being very spartan with application server connection pools can bring
benefits (but can also cause problems).

merlin



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux