Re: PostgreSQL logical decoder output plugin - unchanged toast data

Поиск
Список
Период
Сортировка
От Georgy Buranov
Тема Re: PostgreSQL logical decoder output plugin - unchanged toast data
Дата
Msg-id CAGMDm34EETYgJf_zDUjOH6T=tw-PDQGmgcMOUG+jQwFKcTd5kQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL logical decoder output plugin - unchanged toast data  (Andres Freund <andres@anarazel.de>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_verify_checksums and -fno-strict-aliasing
Следующее
От: Jaime Casanova
Дата:
Сообщение: Re: FailedAssertion on partprune