Postgres Pro
Downloads
Home   >   mailing lists

Thread: Slow DROPing Table

Slow DROPing Table

From
Somazx Interesting
Date:
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.

Re: Slow DROPing Table

From
Jan Wieck
Date:
Somazx Interesting wrote:
>
> 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.

    Run VACUUM from a db superuser account frequently to keep the
    system catalog clean.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com