Slow deletion of data from tables

From: orfenur(at)ulrik(dot)uio(dot)no (Rune Froysa)
To: pgsql-general(at)postgresql(dot)org
Subject: Slow deletion of data from tables
Date: 2004-07-01 16:35:36
Message-ID: 53a989c.0407010835.21f8bf5c@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have one table with columns that are used as foreign-keys from
several other tables. Sometimes deletion from this table takes +5
seconds for a single row. Are there any utilities that can be used to
figure out why the deletion takes so long? "ANALYZE DELETE FROM foo
WHERE bar=gazonk" doesn't really help as it only explains how the
where statement is resolved, and not what postgres has to do to
preserve database integrity.

Regards,

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Juan Jose Costello Levien 2004-07-01 16:44:06 Error loading trigger in C
Previous Message Bruno Wolff III 2004-07-01 16:33:56 Re: permissions