| 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 14:14:10 |
| Message-ID: | CAFj8pRATcY4zXf42fbVeyZLJQ5wbfvUuQVjnLd3sKo7P2NQ+7A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
čt 21. 1. 2021 v 14:37 odesílatel Pavel Stehule <pavel(dot)stehule(at)gmail(dot)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 | Content-Type | Size |
|---|---|---|
| plpgsql-plan-cache-for-call-3.patch | text/x-patch | 44.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | osumi.takamichi@fujitsu.com | 2021-01-21 14:19:18 | RE: Enhance traceability of wal_level changes for backup management |
| Previous Message | Alexey Kondratov | 2021-01-21 14:06:06 | Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly |