Re: LIMIT for UPDATE and DELETE - Mailing list pgsql-hackers

From Marko Tiikkaja
Subject Re: LIMIT for UPDATE and DELETE
Date
Msg-id 54102581.2020207@joh.to
Whole thread Raw
In response to Re: LIMIT for UPDATE and DELETE  (Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>)
List pgsql-hackers
On 9/10/14 12:05 PM, Etsuro Fujita wrote:
> (2014/09/10 18:33), Marko Tiikkaja wrote:
>> You can already change *this patch* to do ModifyTable <- Limit <-
>> LockRows.  If we think that's what we want, we should rewrite this patch
>> right now.
>
> I think it might be relatively easy to do that for single-table cases,
> but for inheritance cases, inheritance_planner needs work and I'm not
> sure how much work it would take ...

Uh.  Yeah, I think I'm an idiot and you're right.

I'll try and get some benchmarking done and see what comes out.


.marko



pgsql-hackers by date:

Previous
From: Etsuro Fujita
Date:
Subject: Re: LIMIT for UPDATE and DELETE
Next
From: Fujii Masao
Date:
Subject: Re: replication commands and log_statements