Horton

Re: patch: reduce overhead of execution of CALL statement in no atomic mode from PL/pgSQL

Pavel Stehule <pavel.stehule@gmail.com>

View thread View on postgr.es
From: Pavel Stehule <pavel.stehule@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>, Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Date: 2021-01-26T04:38:32Z
Lists: pgsql-hackers 
út 26. 1. 2021 v 4:33 odesílatel Tom Lane <tgl@sss.pgh.pa.us> napsal:

> Pavel Stehule <pavel.stehule@gmail.com> writes:
> > [ plpgsql-plan-cache-for-call-3.patch ]
>
> Pushed with some additional cleanup.
>

Thank you

Pavel


> It strikes me that we ought to get rid of SPI_execute_with_receiver
> (which has been added since v13) in favor of a "SPI_execute_extended"
> that shares the same options struct as SPI_execute_plan_extended.
> But I left that for tomorrow.
>
>                         regards, tom lane
>

Commits

  1. Rethink recently-added SPI interfaces.

  2. Improve performance of repeated CALLs within plpgsql procedures.

  3. Add the ability for the core grammar to have more than one parse target.