From: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
---|---|
To: | Somazx Interesting <somazx(at)home(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Slow DROPing Table |
Date: | 2001-06-12 18:34:14 |
Message-ID: | 200106121834.f5CIYEX02592@jupiter.us.greatbridge.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)Yahoo(dot)com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Nicolas Huillard | 2001-06-12 18:35:44 | RE: Exploring sequences (sequence context within a transaction) |
Previous Message | Thalis A. Kalfigopoulos | 2001-06-12 18:25:42 | Re: select, where and null-values (or: select null<>'1' is fuzzy) |