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

From: Evan Walter <ewalter(at)decisionanalyst(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: dropping a large table is taking a very long time (about 2 hours so far)
Date: 2012-09-24 21:10:17
Message-ID: CAOHVLOFBYojG-6tSMB3PM2a2CSO3B434svFGDudLdg5rVCMVLg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Steve Crawford 2012-09-24 21:15:23 Re: dropping a large table is taking a very long time (about 2 hours so far)
Previous Message Marcello Perathoner 2012-09-24 21:05:03 Re: CPU causes 100% load in user space when ntp client runs and postgresql is under heavy load