在 2014/7/30 18:03, Rural Hunter 写道:
I think I understand what happened now. I have another monitor script
runs periodically and calls pg_cancel_backend and pg_terminate_backend
for those hanging update sqls. However for some unkown reason the
cancle and termiante command doesn't work at pgsql s
Hi Tom,
Could my problem be a victim of this issue?
http://postgresql.1045698.n5.nabble.com/Planner-performance-extremely-affected-by-an-hanging-transaction-20-30-times-td5771686.html
is the patch mentioned in that thread applied in 9.2.9?
--
Sent via pgsql-performance mailing list (pgsql-perf
