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-21T13:37:39Z

Lists: pgsql-hackers

Attachments

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

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.

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