On Mon, 2012-04-09 at 16:08 -0400, Tom Lane wrote:
> > When I issue the drop command for a table, the server doesn't
> respond - not
> > even with increased disk activity or CPU usage. I am wondering if a
> lock is
> > blocking it?
>
> Look into pg_locks to find out.
We probably need a better view which joins pg_stat_activity and
pg_locks, along with the new pg_stat_activity column in 9.2, which will
give users better idea about what is locking what...
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz