[ADMIN] Odd DEALLOCATE statements never finish in 9.2?

2012-10-18 Thread Craig James
I installed 9.2 on our new server and am seeing something odd that doesn't happen in 8.4: postgres=# select datname, pid, usename, query from pg_stat_activity where query != 'IDLE'; datname | pid | usename | query

Re: [ADMIN] Odd DEALLOCATE statements never finish in 9.2?

2012-10-18 Thread Tom Lane
Craig James cja...@emolecules.com writes: I installed 9.2 on our new server and am seeing something odd that doesn't happen in 8.4: postgres=# select datname, pid, usename, query from pg_stat_activity where query != 'IDLE'; The query column now means current or last query --- there's a

Re: [ADMIN] Odd DEALLOCATE statements never finish in 9.2?

2012-10-18 Thread Craig James
On Thu, Oct 18, 2012 at 2:54 PM, Tom Lane t...@sss.pgh.pa.us wrote: Craig James cja...@emolecules.com writes: I installed 9.2 on our new server and am seeing something odd that doesn't happen in 8.4: postgres=# select datname, pid, usename, query from pg_stat_activity where query !=