Somazx Interesting <somazx@home.com> writes:
> Can anyone think of anything that would cause dropping a table with little
> data contained within it to take several seconds (and growing)?
Can't see a reason for that offhand.
> - upgraded to 7.1 but not to 7.1.2
I'd strongly recommend moving to 7.1.2; from 7.1 the update is painless,
and there are several pretty critical bugfixes. (We don't make
dot-releases just to amuse ourselves.) I don't think any of them are
related to your problem, but I could be wrong about that.
If you still see the problem in 7.1.2, one possible investigation
technique is to strace the backend doing the drop and see what I/O
requests it's making.
regards, tom lane