Re: Poor Delete performance - Mailing list pgsql-general

From Tom Lane
Subject Re: Poor Delete performance
Date
Msg-id 786.984430439@sss.pgh.pa.us
Whole thread Raw
In response to RE: Poor Delete performance  (Matthew <matt@ctlno.com>)
Responses Re: Poor Delete performance
List pgsql-general
Matthew <matt@ctlno.com> writes:
>     This would be a welcome improvement.  I have for a long time noticed
> very slow delete performance when deleting a large number of records in one
> command.  I can give more detail if so desired.

Is this in a table that contains foreign key references?  (Or, more
generally, has any AFTER UPDATE or AFTER DELETE triggers?)

            regards, tom lane

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: help with simple rule
Next
From: Tom Lane
Date:
Subject: Re: Re: Data types?