From: | Somazx Interesting <somazx(at)home(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Slow droping tables |
Date: | 2001-06-07 04:26:08 |
Message-ID: | 5.1.0.14.0.20010606212349.02ff3fa0@mail.rct1.bc.wave.home.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Hartwig Jens | 2001-06-07 06:02:54 | AW: QUESTION: Automatically generating Primary keys !!! |
Previous Message | Justin Clift | 2001-06-07 02:50:59 | Re: USE_AUSTRALIAN_RULES breaks regression tests in 7.1.2? |