| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
| Cc: | Andres Freund <andres(at)2ndquadrant(dot)com>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila(at)huawei(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Performance bug in prepared statement binding in 9.2? |
| Date: | 2013-09-11 18:35:45 |
| Message-ID: | 5230B801.90507@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
All,
We've confirmed that this issue is caused by having long-running idle
transactions on the server. When we disabled their queueing system
(which prodiced hour-long idle txns), the progressive slowness went away.
Why that should affect 9.X far more strongly than 8.4, I'm not sure
about. Does that mean that 8.4 was unsafe, or that this is something
which *could* be fixed in later versions?
I'm also confused as to why this would affect BIND time rather than
EXECUTE time.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2013-09-11 19:06:23 | Re: Performance bug in prepared statement binding in 9.2? |
| Previous Message | Merlin Moncure | 2013-09-11 18:26:04 | Re: Intermittent hangs with 9.2 |