Re: Slow deletes - Mailing list pgsql-general

From Tom Lane
Subject Re: Slow deletes
Date
Msg-id 21751.1029209909@sss.pgh.pa.us
Whole thread Raw
In response to Re: Slow deletes  (Edmund Dengler <edmundd@eSentire.com>)
Responses Re: Slow deletes
List pgsql-general
Edmund Dengler <edmundd@eSentire.com> writes:
> Anyway to conveniently dump the triggers (3 are constraint check, my own
> personal one is suppose to be on inserts only)?

The RI on-delete trigger must be the issue then.  Lack of indexes, or
linking to a foreign key of a different column type are the trouble
causes I've seen there ...

            regards, tom lane

pgsql-general by date:

Previous
From: Edmund Dengler
Date:
Subject: Re: Slow deletes
Next
From: Edmund Dengler
Date:
Subject: Re: Slow deletes