Query related to Logical Replication using test_decoding and unchanged-toast-datum - Mailing list pgsql-general

From Kiran K V
Subject Query related to Logical Replication using test_decoding and unchanged-toast-datum
Date
Msg-id CAGv0ivrBc=X6iaWA9Fng7u8D5BbM6EbcNy-4xF0DGFrAV+c2zw@mail.gmail.com
Whole thread Raw
Responses Re: Query related to Logical Replication using test_decoding and unchanged-toast-datum
List pgsql-general
Hi,

I am currently using PostgreSQL version 16 and the test_decoding plugin to perform logical replication (using replication slots). I have a simple table with integer column and JSON column. When a non-JSON column is updated, the value "unchanged-toast-datum" for the JSON column is obtained. This shows that the value recorded in a TOAST table for a JSON column value has not changed and is as expected. could you please tell me whether PostgreSQL will truly log these values to WAL or not ? If not, what will be entered into WAL for the JSON column if it remains unchanged?

Please let me know. Thank you very much.

Regards,
Kiran

pgsql-general by date:

Previous
From: Dominique Devienne
Date:
Subject: Re: Will PQsetSingleRowMode get me results faster?
Next
From: "David G. Johnston"
Date:
Subject: Re: Query related to Logical Replication using test_decoding and unchanged-toast-datum