Re: making update/delete of inheritance trees scale better

From: Amit Langote <amitlangote09(at)gmail(dot)com>
To: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: making update/delete of inheritance trees scale better
Date: 2020-11-13 09:52:34
Message-ID: CA+HiwqGb=4s644wB40pPafwcJbuOTgwTGE0ivR1C2eq7nxMLyg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Nov 11, 2020 at 9:11 PM Heikki Linnakangas <hlinnaka(at)iki(dot)fi> wrote:
> On 29/10/2020 15:03, Amit Langote wrote:
> > Rebased over the recent executor result relation related commits.
>
> ModifyTablePath didn't get the memo that a ModifyTable can only have one
> subpath after these patches. Attached patch, on top of your v5 patches,
> cleans that up.

Ah, thought I'd taken care of that, thanks. Attached v6.

--
Amit Langote
EDB: http://www.enterprisedb.com

Attachment Content-Type Size
v6-0001-Overhaul-how-updates-compute-a-new-tuple.patch application/octet-stream 76.2 KB
v6-0002-Revise-how-inherited-update-delete-are-handled.patch application/octet-stream 203.4 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message kuroda.hayato@fujitsu.com 2020-11-13 10:27:47 RE: Terminate the idle sessions
Previous Message Julien Rouhaud 2020-11-13 09:50:09 Re: Supporting = operator in gin/gist_trgm_ops