Skip site navigation (1) Skip section navigation (2)

Re: Is IDLE session really idle?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Igor Polishchuk <ipolishchuk(at)hi5(dot)com>
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Is IDLE session really idle?
Date: 2009-06-15 23:19:16
Message-ID: 27435.1245107956@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Igor Polishchuk <ipolishchuk(at)hi5(dot)com> writes:
> ... Eventually, the database just hangs and the host
> becomes unresponsive for about 15 minutes till the sessions die out.

Well, that's a problem all right, but I'm entirely unconvinced by your
hypothesis about what's causing it.  Have you tried watching "vmstat"
(particularly the swap rate) while things go downhill?  Do any signs
of distress start to appear in the postmaster log or other system logs?
Do other services on the box start to fail, and if so what are they
complaining about?

> Isn't it true, that work memory once allocated for a  session does not get
> deallocated till the sessions is closed?

No.

			regards, tom lane

In response to

pgsql-admin by date

Next:From: Premila DeviDate: 2009-06-16 02:22:52
Subject: Database Import..Please Help Me
Previous:From: Tom LaneDate: 2009-06-15 23:03:23
Subject: Re: Pgsql remote connection issue was: Regarding PostgreSQL problem.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group