pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Odd DEALLOCATE statements never finish in 9.2? 3+ messages / 2 participants [nested] [flat]
* Odd DEALLOCATE statements never finish in 9.2? @ 2012-10-18 21:47 Craig James <cjames@emolecules.com> 0 siblings, 1 reply; 3+ messages in thread From: Craig James @ 2012-10-18 21:47 UTC (permalink / raw) To: 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Odd DEALLOCATE statements never finish in 9.2? @ 2012-10-18 21:54 Tom Lane <tgl@sss.pgh.pa.us> parent: Craig James <cjames@emolecules.com> 0 siblings, 1 reply; 3+ messages in thread From: Tom Lane @ 2012-10-18 21:54 UTC (permalink / raw) To: Craig James <cjames@emolecules.com>; +Cc: pgsql-admin Craig James <cjames@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 separate column to check for the idle status. Those DEALLOCATEs are evidently what your app does before going idle. regards, tom lane ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Odd DEALLOCATE statements never finish in 9.2? @ 2012-10-18 22:05 Craig James <cjames@emolecules.com> parent: Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 3+ messages in thread From: Craig James @ 2012-10-18 22:05 UTC (permalink / raw) To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin On Thu, Oct 18, 2012 at 2:54 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote: > Craig James <cjames@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 > separate column to check for the idle status. Those DEALLOCATEs > are evidently what your app does before going idle. > Nice feature. Thanks. Craig > > regards, tom lane > ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2012-10-18 22:05 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2012-10-18 21:47 Odd DEALLOCATE statements never finish in 9.2? Craig James <cjames@emolecules.com> 2012-10-18 21:54 ` Tom Lane <tgl@sss.pgh.pa.us> 2012-10-18 22:05 ` Craig James <cjames@emolecules.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox