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 Steve Crawford
Subject Re: dropping a large table is taking a very long time (about 2 hours so far)
Date
Msg-id 5060CD6B.4010404@pinpointresearch.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 09/24/2012 02:10 PM, Evan Walter 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?
I'd check for locks from other transactions preventing the drop. One
possibility is a running backup.

Cheers,
Steve

pgsql-admin by date:

Previous
From: Evan Walter
Date:
Subject: dropping a large table is taking a very long time (about 2 hours so far)
Next
From: henk de wit
Date:
Subject: Spurious failure to obtain row lock possible in PG 9.1?