Re: 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]

 



On Sep 24, 2012, at 5:10 PM, Evan Walter <ewalter@xxxxxxxxxxxxxxxxxxx> 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?


Not to me. I would have checked if DROP command is in waiting state. Also looked at pg_locks for more information on locks.

Thanks & Regards,
Vibhor Kumar
Blogs:http://vibhork.blogspot.com
http://vibhorkumar.wordpress.com



-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



[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