Postgres Pro
Downloads
Home   >   mailing lists

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

From Evan Walter
Subject dropping a large table is taking a very long time (about 2 hours so far)
Date
Msg-id CAOHVLOFBYojG-6tSMB3PM2a2CSO3B434svFGDudLdg5rVCMVLg@mail.gmail.com
Whole thread Raw
Responses Re: dropping a large table is taking a very long time (about 2 hours so far)  (Steve Crawford <scrawford@pinpointresearch.com>)
Re: dropping a large table is taking a very long time (about 2 hours so far)  (Vibhor Kumar <vibhor.aim@gmail.com>)
List pgsql-admin
Tree view
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?

pgsql-admin by date:

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