Re: BUG #18722: Processing arrays with plpgsql raises errors - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #18722: Processing arrays with plpgsql raises errors
Date
Msg-id 1341819.1732547251@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #18722: Processing arrays with plpgsql raises errors  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Responses Re: BUG #18722: Processing arrays with plpgsql raises errors
List pgsql-bugs
Dean Rasheed <dean.a.rasheed@gmail.com> writes:
> On Sun, 24 Nov 2024 at 22:49, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Here's a fleshed-out patch with a test case and JIT support.  This
>> is about the first time I've messed with LLVM, so I wouldn't mind
>> some review of what I did in llvmjit_expr.c.  In particular, do I
>> correctly understand that "l_funcvalue(b, v_fcinfo, 0)" produces
>> a reference to a copy of the initial value of args[0].value?

> I don't know about that, but I wonder if this bug could be fixed by
> having ExecInitExprRec() insert a EEOP_MAKE_READONLY step. Then it
> wouldn't be necessary to make any changes to the expression evaluation
> code.

That would entirely destroy one of the primary performance benefits of
the expanded-object infrastructure.  The idea is that if you have
    fconsumer(fproducer(...), ...)
and fproducer returns a read-write pointer to an object it's built,
then fconsumer should be able to take ownership of the object and
use it as a local variable (possibly modifying it) without incurring
any object-copying overhead.

This works in any context where an intermediate expression value
has a single consumer, which is most.  If there are multiple
consumers then we need to insert MAKE_READONLY steps for all
(or all but one) of them.  I overlooked EEOP_NULLIF as such
a case, but I don't think there are so many more cases as to
justify throwing away the concept altogether.

            regards, tom lane



pgsql-bugs by date:

Previous
From: Christophe Pettus
Date:
Subject: Re: BUG #18724: High data disk utilization during log writing
Next
From: Tom Lane
Date:
Subject: Re: Detection of hadware feature => please do not use signal