Re: DELETE performance problem

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: DELETE performance problem
Date: 2009-11-24 16:07:59
Message-ID: 200911240807.59452@hal.medialogik.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tuesday 24 November 2009, Thom Brown <thombrown(at)gmail(dot)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."

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew Wakeling 2009-11-24 17:23:10 RAID card recommendation
Previous Message Matthew Wakeling 2009-11-24 15:41:09 Re: [PERFORM] Strange performance degradation