Re: Minimal logical decoding on standbys

From: "Drouvot, Bertrand" <bertranddrouvot(dot)pg(at)gmail(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Ibrar Ahmed <ibrar(dot)ahmad(at)gmail(dot)com>, Amit Khandekar <amitdkhan(dot)pg(at)gmail(dot)com>, fabriziomello(at)gmail(dot)com, tushar <tushar(dot)ahuja(at)enterprisedb(dot)com>, Rahila Syed <rahila(dot)syed(at)2ndquadrant(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Minimal logical decoding on standbys
Date: 2023-02-07 15:29:07
Message-ID: b74520d5-5b9e-1477-2abc-95ba897f23e4@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On 1/19/23 10:43 AM, Drouvot, Bertrand wrote:
> Hi,
>
> On 1/19/23 3:46 AM, Andres Freund wrote:
>> Hi,
>>
>> On 2023-01-18 11:24:19 +0100, Drouvot, Bertrand wrote:
>>> On 1/6/23 4:40 AM, Andres Freund wrote:
>>>> Hm, that's quite expensive. Perhaps worth adding a C helper that can do that
>>>> for us instead? This will likely also be needed in real applications after all.
>>>>
>>>
>>> Not sure I got it. What the C helper would be supposed to do?
>>
>> Call LogStandbySnapshot().
>>
>
> Got it, I like the idea, will do.
>

0005 in V49 attached is introducing a new pg_log_standby_snapshot() function
and the TAP test is making use of it.

Documentation about this new function is also added in the "Snapshot Synchronization Functions"
section. I'm not sure that's the best place for it but did not find a better place yet.

Regards,

--
Bertrand Drouvot
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com

Attachment Content-Type Size
v49-0006-Doc-changes-describing-details-about-logical-dec.patch text/plain 2.2 KB
v49-0005-New-TAP-test-for-logical-decoding-on-standby.patch text/plain 33.4 KB
v49-0004-Fixing-Walsender-corner-case-with-logical-decodi.patch text/plain 7.7 KB
v49-0003-Allow-logical-decoding-on-standby.patch text/plain 11.8 KB
v49-0002-Handle-logical-slot-conflicts-on-standby.patch text/plain 37.0 KB
v49-0001-Add-info-in-WAL-records-in-preparation-for-logic.patch text/plain 76.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2023-02-07 15:29:57 Re: SQLFunctionCache and generic plans
Previous Message Justin Pryzby 2023-02-07 15:25:42 Re: run pgindent on a regular basis / scripted manner