Si Chen <[email protected]> writes: > Is there a way to configure postgresql to automatically release connections > that have been idle for a set amount of time?
I've seen recent discussion in hackers that this may be added to an upcoming release. > On Wed, Jun 11, 2014 at 3:41 PM, Merlin Moncure <[email protected]> wrote: > > On Wed, Jun 11, 2014 at 5:37 PM, Si Chen > <[email protected]> wrote: > > The state is "idle". Â I don't have the state_change, but I will try to > > collect it if it happens again. > > If they are idle, then the problem is probably with your application > -- you're grabbing new connections and not closing them or reusing > them. Â It's a very common problem. Â The 'query' when idle represents > the last query run -- the database finished it and is sitting around. > > merlin > > -- > Si Chen > Open Source Strategies, Inc. > [email protected] > http://www.OpenSourceStrategies.com > LinkedIn: http://www.linkedin.com/in/opentaps > Twitter: http://twitter.com/opentaps > -- Jerry Sievers Postgres DBA/Development Consulting e: [email protected] p: 312.241.7800 -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
