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-21T14:14:10Z

Lists: pgsql-hackers

Attachments

plpgsql-plan-cache-for-call-3.patch (text/x-patch) patch

čt 21. 1. 2021 v 14:37 odesílatel Pavel Stehule <pavel.stehule@gmail.com>
napsal:

> Hi
>
> This is a little bit of an enhanced version of the previous patch. The
> worst case overhead is reduced almost to zero. The local resource owner is
> created only when routine is executed in non-atomic mode, and when routine
> contains a CALL statement.
>

Sorry. Last patch wasn't tested well.

Regards

Pavel




> Regards
>
> Pavel
>
>

Commits

Rethink recently-added SPI interfaces.
- d5a83d79c9f9 14.0 landed
Improve performance of repeated CALLs within plpgsql procedures.
- ee895a655ce4 14.0 landed
Add the ability for the core grammar to have more than one parse target.
- 844fe9f159a9 14.0 cited