Re: dropping a large table is taking a very long time (about 2 hours so far)

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: Evan Walter <ewalter(at)decisionanalyst(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: dropping a large table is taking a very long time (about 2 hours so far)
Date: 2012-09-24 21:15:23
Message-ID: 5060CD6B.4010404@pinpointresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

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