I am working on a performance issue with a partitioned table. Some of my sql
statements against this partition table is in waiting state for long time. I
have queried waiting=true in pg_stat_activity. Now, is there a way to find
out which sql is making other statements to wait.
Thanks for your help.
View this message in context: http://postgresql.1045698.n5.nabble.com/postgresql-statements-are-waiting-tp3285939p3285939.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
pgsql-performance by date
|Next:||From: pasman pasmański||Date: 2010-11-30 11:43:05|
|Subject: tidscan not work ? Pg 8.4.5 + WinXP|
|Previous:||From: Robert Haas||Date: 2010-11-30 00:21:59|
|Subject: Re: MVCC performance issue|