On Tue, Nov 30, 2010 at 4:38 AM, bakkiya wrote:
>
> Hi,
> 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 w
bakkiya wrote:
> 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 t
Hi,
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 you
