Обсуждение: Slow droping tables
It would seem that my postgresql database system is getting slower and slower at dropping tables and possibly other tasks too. Am I being paranoid? I don't think so. Can anyone think of anything that would cause dropping a table with little data contained within it to take several seconds (and growing)? I have vacuumed the database. Here is a list of guessed on the factors which may be involved: - there are several short/simpler triggers calling tcl functions on each table. - upgraded to 7.1 but not to 7.1.2 - there is very little data in any of the tables - the project is still under development and isn't getting any traffic - we use scripts which create tables and while testing we've created and dropped a lot of tables - dropping a small table with little or nothing in it results in seconds of hard drive churning. Thanks for any feedback. Andy Koch.
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