| From: | Somazx Interesting <somazx(at)home(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Slow DROPing Table |
| Date: | 2001-06-06 18:49:41 |
| Message-ID: | 5.1.0.14.0.20010606114102.00aa3d10@mail.rct1.bc.wave.home.com |
| Views: | Whole Thread | Raw Message | 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 triggers on each table.
- the table does have a referential constraint ON DELETE CASCADE
- 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, we CREATE and DROP a lot of tables
Thanks for any feedback.
Andy Koch.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2001-06-06 18:50:15 | Re: [SQL] maximum number of rows in table - what about oid limits? |
| Previous Message | John Scott | 2001-06-06 18:45:08 | Re: [SQL] maximum number of rows in table - what about oid limits? |