From: | Corey Huinker <corey(dot)huinker(at)gmail(dot)com> |
---|---|
To: | vignesh C <vignesh21(at)gmail(dot)com> |
Cc: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-hackers(at)lists(dot)postgresql(dot)org |
Subject: | Re: Document efficient self-joins / UPDATE LIMIT techniques. |
Date: | 2024-02-03 20:27:53 |
Message-ID: | CADkLM=dk9E6OjPxK48JL9+=5LjnWEtt_a-kryS-NZSP5_PibEw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>
> I have changed the status of commitfest entry to "Returned with
> Feedback" as Laurenz's comments have not yet been resolved. Please
> handle the comments and update the commitfest entry accordingly.
>
>
Here's another attempt, applying Laurenz's feedback:
I removed all changes to the SELECT documentation. That might seem strange
given that the heavy lifting happens in the SELECT, but I'm working from
the assumption that people's greatest need for a ctid self-join will be
because they are trying to find the LIMIT keyword on UPDATE/DELETE and
coming up empty.
Because the join syntax is subtly different between UPDATE and DELETE, I've
kept code examples in both, but the detailed explanation is in UPDATE under
the anchor "update-limit" and the DELETE example links to it.
Attachment | Content-Type | Size |
---|---|---|
v2-0001-Documentation-Show-alternatives-to-LIMIT-on-UPDAT.patch | text/x-patch | 3.8 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | jian he | 2024-02-04 00:00:00 | Re: Should we remove -Wdeclaration-after-statement? |
Previous Message | Andrey M. Borodin | 2024-02-03 17:32:45 | Re: MultiXact\SLRU buffers configuration |