| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Premila Devi | 2009-06-16 02:22:52 | Database Import..Please Help Me |
| Previous Message | Tom Lane | 2009-06-15 23:03:23 | Re: Pgsql remote connection issue was: Regarding PostgreSQL problem. |