| From: | Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Steve Horn <steve(at)stevehorn(dot)cc>, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Cannot DROP while process running |
| Date: | 2012-04-09 20:12:47 |
| Message-ID: | 1334002367.27334.14.camel@lenovo01-laptop03.gunduz.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Horn | 2012-04-09 21:07:35 | Re: Cannot DROP while process running |
| Previous Message | Tom Lane | 2012-04-09 20:08:55 | Re: Cannot DROP while process running |