From: | Michel Pelletier <pelletier(dot)michel(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | 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: | 2024-12-08 07:05:13 |
Message-ID: | CACxu=vL4g2pPgEg66F-ttZ5jVuMba8K31vsoEYKbTJ7q6jk0hg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
On Fri, Dec 6, 2024 at 4:51 PM Michel Pelletier <pelletier(dot)michel(at)gmail(dot)com>
wrote:
>
> My question is about nvals = nvals(graph) in that function above, the
> object is flattened and then rexpanded, even after the object was expanded
> and returned by wait() [1] into a r/w pointer.
>
...
>
> mxm calls expand_matrix three times for each of the three arguments.
> Ideally I'd like the already expanded rw pointer from wait() to be honored
> by mxm so that it doesn't re-expand the object three times but, like
> set_element, not at all.
>
My bad, sorry for the long confusing email, I figured out that I was
calling the wrong macro when getting my matrix datum and inadvertently
expanding RO pointers as well, I've fixed that issue, and everything is
working great! No extra expansions and my support functions are working
well, I need to go through a few more places in the API to add more support
but otherwise the fixes Tom has put into plpgsql have worked perfectly and
the library now appears to be behaving optimally! I can get down to doing
some benchmarks and head-to-head with the C and Python bindings to compare
against.
Thanks for your help Tom, I'm looking forward to the changes being released
soon! In the meanwhile I'll keep a locally patched version for ongoing
testing purposes.
-Michel
>
From | Date | Subject | |
---|---|---|---|
Next Message | Will Storey | 2024-12-09 00:42:38 | Cancelled query due to buffer deadlock with recovery |
Previous Message | Adrian Klaver | 2024-12-08 00:49:50 | Re: Insert records in the tavke only if they are not exist |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrei Lepikhov | 2024-12-08 08:44:23 | Re: Do not scan index in right table if condition for left join evaluates to false using columns in left table |
Previous Message | Tomas Vondra | 2024-12-08 04:23:26 | Re: Trim the heap free memory |