Re: PostgreSQL logical decoder output plugin - unchanged toast data

Поиск
Список
Период
Сортировка
От Georgy Buranov
Тема Re: PostgreSQL logical decoder output plugin - unchanged toast data
Дата
Msg-id CAGMDm35y_zzwEpcLUs=YGQeXEuEtW9M0OsrAhooFtFmXQTNkVA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL logical decoder output plugin - unchanged toast data  (Andres Freund <andres@anarazel.de>)
Ответы Re: PostgreSQL logical decoder output plugin - unchanged toast data
Список pgsql-hackers
Ok, thank you very much for your explanation,

maybe I need something else in my case.

As far as I understand, "On-disk toasted data for tuples from the WAL
are not guaranteed in any way to be retain", but still, the LATEST
value for the same cell should exist in postgres (in on-disk toast if
it is huge, or not).

If I cannot get access to the on-disk toasted data for tuple from the
WAL, can I have the access to the _latest_ value in this case
(hopefully I describe it correct)

> Yes, that's not possible in general. On-disk toasted data for tuples
> from the WAL are not guaranteed in any way to be retained. If that
> weren't the case database tables would bloat while logical replication
> is behind, and the sequential reads (i.e. fast) reads of logical
> decoding would turn into random IO.

Mit freundlichen Grüßen,
Georgy Buranov


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_verify_checksums and -fno-strict-aliasing
Следующее
От: Tom Lane
Дата:
Сообщение: Re: remove ancient pre-dlopen dynloader code