Re: Using Expanded Objects other than Arrays from plpgsql

From: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Michel Pelletier <pelletier(dot)michel(at)gmail(dot)com>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Using Expanded Objects other than Arrays from plpgsql
Date: 2025-01-26 10:07:22
Message-ID: 0AC229FA-A3F1-43FD-B0DC-A46A73FEAFF7@yandex-team.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hello everyone in this thread.

> On 21 Jan 2025, at 23:12, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> somebody will review this

I'm trying to dig into the patch set. My knowledge of the module is shallow and I hope to improve it by reading more patches in this area.

This patch set provides a new test, which runs just fine without the patch. But it's somewhat expected, such optimizations must be transparent for user...

And the coverage of newly invented mark_stmt() 42.37%. Some of branches are easy noops, but some are not.
I assume as a granted that we will not every get into infinite loop in a recursive call of mark_stmt().

expr_is_assignment_source() is named like if it should return nool, but it's void.

I could not grasp from reading the code one generic question about new optimization rule. What cost does checking for possible in-place update incurs to code cannot have this optimization? Is it O(numer_of_arguments) of for every assignment execution?

Thanks!

Best regards, Andrey Borodin.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Дмитрий 2025-01-26 11:29:16 Re[2]: FATAL: could not send data to WAL stream: lost synchronization with server: got message type "0", length 892351284
Previous Message Adrian Klaver 2025-01-25 17:32:27 Re: FATAL: could not send data to WAL stream: lost synchronization with server: got message type "0", length 892351284

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2025-01-26 10:26:35 Re: Convert sepgsql tests to TAP
Previous Message Jacob Brazeal 2025-01-26 07:35:51 Re: MAX_BACKENDS size (comment accuracy)