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
