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

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: patch: reduce overhead of execution of CALL statement in no atomic mode from PL/pgSQL
Date: 2020-11-03 17:27:34
Message-ID: CAFj8pRBgjGtUrRUEMk-oAx+apEyfh74GVC4Hj2FPsCutv81m8Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Attachment Content-Type Size
call-graph-profile.gz application/gzip 68.0 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephen Frost 2020-11-03 17:47:34 Re: automatic analyze: readahead - add "IO read time" log message
Previous Message David G. Johnston 2020-11-03 17:20:53 Re: PATCH: Batch/pipelining support for libpq