Postgres Pro
Downloads
Home   >   mailing lists

Re: patch: reduce overhead of execution of CALL statement in no atomic mode from PL/pgSQL - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: patch: reduce overhead of execution of CALL statement in no atomic mode from PL/pgSQL
Date
Msg-id CAFj8pRATcY4zXf42fbVeyZLJQ5wbfvUuQVjnLd3sKo7P2NQ+7A@mail.gmail.com
Whole thread Raw
In response to Re: patch: reduce overhead of execution of CALL statement in no atomic mode from PL/pgSQL  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: patch: reduce overhead of execution of CALL statement in no atomic mode from PL/pgSQL  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view


č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

Attachment

pgsql-hackers by date:

Previous
From: Alexey Kondratov
Date:
Subject: Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly
Next
From: "osumi.takamichi@fujitsu.com"
Date:
Subject: RE: Enhance traceability of wal_level changes for backup management