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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: dropping a large table is taking a very long time (about 2 hours so far)
From: Evan Walter <ewalter@xxxxxxxxxxxxxxxxxxx>
Date: Mon, 24 Sep 2012 16:10:17 -0500
Sender: pgsql-admin-owner@xxxxxxxxxxxxxx

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?

Follow-Ups:
- Re: dropping a large table is taking a very long time (about 2 hours so far)
  - From: Vibhor Kumar
- Re: dropping a large table is taking a very long time (about 2 hours so far)
  - From: Steve Crawford

Prev by Date: Re: CPU causes 100% load in user space when ntp client runs and postgresql is under heavy load
Next by Date: Re: dropping a large table is taking a very long time (about 2 hours so far)
Previous by thread: CPU causes 100% load in user space when ntp client runs and postgresql is under heavy load
Next by thread: Re: dropping a large table is taking a very long time (about 2 hours so far)
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]

Powered by Linux