| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: idle in transaction query makes server unresponsive |
| Date: | 2012-09-25 21:12:12 |
| Message-ID: | 50621E2C.5010607@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 09/25/12 1:35 PM, Scot Kreienkamp wrote:
> The problem is how do I investigate this when PG is entirely unresponsive? Why is it becoming unresponsive, and how do I prevent the PG server from becoming unresponsive?
I think I'd push that 9.1.latest upgrade ASAP, and then see if this
problem continues. been a pile of critical fixes since 9.1.2, to whit...
http://www.postgresql.org/docs/current/static/release-9-1-3.html
http://www.postgresql.org/docs/current/static/release-9-1-4.html
http://www.postgresql.org/docs/current/static/release-9-1-5.html
http://www.postgresql.org/docs/current/static/release-9-1-6.html
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Kellerer | 2012-09-25 21:25:26 | Re: idle in transaction query makes server unresponsive |
| Previous Message | Joel Hoffman | 2012-09-25 21:10:28 | Re: Rank based on the number of matching OR fields? |