Robert Kaye <rob@xxxxxxxxxxxxxxx> wrote: > However, I am glad to report that our problems are fixed and that our server is > back to humming along nicely. > > What we changed: > > 1. As it was pointed out here, max_connections of 500 was in fact insanely > high, especially in light of using PGbouncer. Before we used PGbouncer we > needed a lot more connections and when we started using PGbouncer, we never > reduced this number. > > 2. Our server_lifetime was set far too high (1 hour). Josh Berkus suggested > lowering that to 5 minutes. > > 3. We reduced the number of PGbouncer active connections to the DB. > Many thanks for the feedback! Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
