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

[Evan Walter]

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?

[Steve Crawford]

Post by Evan Walter
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

[Vibhor Kumar]

Post by Evan Walter
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