Postgres Pro
Downloads
Home   >   mailing lists

Re: dropping a large table is taking a very long time (about 2 hours so far) - Mailing list pgsql-admin

From Vibhor Kumar
Subject Re: dropping a large table is taking a very long time (about 2 hours so far)
Date
Msg-id B0703573-E6A2-458D-96D1-FB2E2EE905E1@gmail.com
Whole thread Raw
In response to dropping a large table is taking a very long time (about 2 hours so far)  (Evan Walter <ewalter@decisionanalyst.com>)
List pgsql-admin
Tree view 
On Sep 24, 2012, at 5:10 PM, Evan Walter <ewalter@decisionanalyst.com> wrote:

> There were probaby about 5 million records in the table.  I do not believe
> there were any foreign keys to the table  The drop table has been going for
> over 2 hours.  Is that normal?


Not to me. I would have checked if DROP command is in waiting state. Also looked at pg_locks for more information on
locks.

Thanks & Regards,
Vibhor Kumar
Blogs:http://vibhork.blogspot.com
http://vibhorkumar.wordpress.com

pgsql-admin by date:

Previous
From: henk de wit
Date:
Subject: Spurious failure to obtain row lock possible in PG 9.1?
Next
From: Greg Williamson
Date:
Subject: file descriptors still open to deleted files