| From: | Craig James <cjames(at)emolecules(dot)com> | 
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org | 
| Subject: | Odd DEALLOCATE statements never finish in 9.2? | 
| Date: | 2012-10-18 21:47:49 | 
| Message-ID: | CAFwQ8rfvsRe0XJt6F=TS6TB0=02xshTK_TNE=BkDa2SO4wQJPQ@mail.gmail.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-admin | 
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
------------+-------+----------+------------------------------------------------------------------------------------
 emolecules | 19249 | test | DEALLOCATE dbdpg_p18629_26
 emolecules | 19250 | test | DEALLOCATE dbdpg_p18625_20
 emolecules | 19251 | test | DEALLOCATE dbdpg_p18632_23
 postgres   | 21583 | postgres | select datname, pid, usename, query from
pg_stat_activity where query != '<IDLE>';
 emolecules | 19253 | test | DEALLOCATE dbdpg_p18627_18
 emolecules | 19320 | test | DEALLOCATE dbdpg_p18640_7
 emolecules | 19271 | test | DEALLOCATE dbdpg_p18628_17
 emolecules | 19779 | test | DEALLOCATE dbdpg_p19319_2
 emolecules | 19282 | test | DEALLOCATE dbdpg_p18626_12
 emolecules | 19321 | test | DEALLOCATE dbdpg_p19283_9
There are indeed nine Postgres backends running.  They are connected to
nine "fastcgi" Apache processes that sit there and wait for low-overhead
requests.
What are these DEALLOCATE requests, and why do they just sit there and
never finish?
Thanks,
Craig
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2012-10-18 21:54:46 | Re: Odd DEALLOCATE statements never finish in 9.2? | 
| Previous Message | Albe Laurenz | 2012-10-18 20:21:53 | Re: Streaming Replication (Master Delta Sync) |