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: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
Subject: Re: patch: reduce overhead of execution of CALL statement in no atomic mode from PL/pgSQL
Date: 2021-01-21 13:37:39
Message-ID: CAFj8pRDgdCaDWEbm=k5cV7xkhoD=FM6MO7oxmkT34unTDu9MfA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Attachment Content-Type Size
plpgsql-plan-cache-for-call-2.patch text/x-patch 44.3 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexey Kondratov 2021-01-21 14:06:06 Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly
Previous Message Alvaro Herrera 2021-01-21 13:35:10 Re: Jsonpath ** vs lax mode