Re: PostgreSQL logical decoder output plugin - unchanged toast data - Mailing list pgsql-hackers

From Georgy Buranov
Subject Re: PostgreSQL logical decoder output plugin - unchanged toast data
Date
Msg-id CAGMDm34EETYgJf_zDUjOH6T=tw-PDQGmgcMOUG+jQwFKcTd5kQ@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL logical decoder output plugin - unchanged toast data  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Ok, I got false understanding that REPLICA IDENTITY is used for
something more than a WAL. This is basically not true. So, what I can
do

* Set the REPLICA IDENTITY to full, and in this case I can still get
the pk from rd_pkindex. In this case the WAL will be bigger, but we
will have all the values in it.
* Other solution is basically (since we know exact primary key) - get
the row, and take the latest value from there using SQL query on the
client side (other part of kafka)

Thank you very much fro your help

> What do you mean with "ineffective"?  That there's more data in the WAL?
> Sure. Otherwise I don't know what you could mean.
>
> There's no free lunch :/


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_verify_checksums and -fno-strict-aliasing
Next
From: Jaime Casanova
Date:
Subject: Re: FailedAssertion on partprune