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

Pavel Stehule <pavel.stehule@gmail.com>

From: Pavel Stehule <pavel.stehule@gmail.com>

To: PostgreSQL Hackers <pgsql-hackers@postgresql.org>, Peter Eisentraut <peter.eisentraut@2ndquadrant.com>, Tom Lane <tgl@sss.pgh.pa.us>

Date: 2020-11-03T17:27:34Z

Lists: pgsql-hackers

Attachments

call-graph-profile.gz (application/gzip)

Hi

I played with the profiler a little bit to get some data - see attached
file.  Almost all overhead is related to impossibility to use simple
expression evaluation (that has very good performance now).

Probably there is no simple way to reduce this overhead.

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