What version of postgres are you on?
From: Satish Burnwal (sburnwal) [mailto:sburn...@cisco.com]
Sent: Tuesday, April 13, 2010 8:04 AM
To: Plugge, Joe R.; pgsql-general@postgresql.org
Cc: pgsql-ad...@postgresql.org
Subject: RE: Query is stuck
controlsmartdb=# select * from pg_stat_activity where
What do you get when you run this?
select * from pg_stat_activity where waiting='t';
From: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Satish Burnwal (sburnwal)
Sent: Tuesday, April 13, 2010 7:58 AM
To: pgsql-general@postgresql.org
Cc: pgsql-ad...@po
Can you provide the layout of your table and all indexes that are present on
said table?
Sounds like a incorrectly indexed table possibly.
-Original Message-
From: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of shohorab hossain
Sent: Tuesday, Nov
