Re: DELETE performance problem - Mailing list pgsql-performance

From Alan Hodgson
Subject Re: DELETE performance problem
Date
Msg-id 200911240807.59452@hal.medialogik.com
Whole thread Raw
In response to Re: DELETE performance problem  (Thom Brown <thombrown@gmail.com>)
List pgsql-performance
On Tuesday 24 November 2009, Thom Brown <thombrown@gmail.com> wrote:
>
> It's a shame there isn't a LIMIT option on DELETE so this can be done in
> small batches.

delete from table where pk in (select pk from table where delete_condition
limit X);


--
"No animals were harmed in the recording of this episode. We tried but that
damn monkey was just too fast."

pgsql-performance by date:

Previous
From: Matthew Wakeling
Date:
Subject: Re: Strange performance degradation
Next
From: Matthew Wakeling
Date:
Subject: RAID card recommendation