Re: [HACKERS] Logical Replication - test_decoding - unchanged-toast-datum

Поиск
Список
Период
Сортировка
От Abhinav Singh
Тема Re: [HACKERS] Logical Replication - test_decoding - unchanged-toast-datum
Дата
Msg-id CALm8xzj+124HEEGB6vowmwioCdrb=mUGVx-MONwd4KE+PZhT0w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Logical Replication - test_decoding - unchanged-toast-datum  (Euler Taveira <euler@timbira.com.br>)
Список pgsql-hackers
Дерево обсуждения
Hello Euler,

Thank you very for your prompt response. 

I am really very sorry that I didn't mention about my exact question. So as you can see from my previous email, in the replication slot I see the value 'unchanged-toast-datum' for the column of dataytpe 'character varying'.

Based on this, when I query my target PostgreSQL instance after the UPDATE statement is run,  the value in this column gets changed to 'unchanged-toast-datum'. The steps that I gave is a simple reproduction and I would request you to please give that a try as well.

Hence, my question is how can workaroud this issue or is there a resolution for this problem.

Kindly review and please share your comments.

Thanks and Regards,
Abhinav Singh

On Tue, Sep 26, 2017 at 6:25 PM, Euler Taveira <euler@timbira.com.br> wrote:
2017-09-26 1:11 GMT-03:00 Abhinav Singh <abhinav.thegame@gmail.com>:
> 5. On the target, when I do a select * and see that the column with
> character varying() datatype has changed to 'unchanged-toast-datum'.
>
The column "is_toast" didn't change its value to
"unchanged-toast-datum". It is just a test_decoding convention that
means that the value is stored in a TOAST table and it was not
changed. test_decoding doesn't show TOAST values to avoid performance
problems and to be brief. Try a SELECT in the table and you will see
that the value is already there.

You didn't write an explicit question but I believe it was your doubt,
didn't it?


--
   Euler Taveira                                   Timbira -
http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

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

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: [HACKERS] path toward faster partition pruning
Следующее
От: Amit Langote
Дата:
Сообщение: Re: [HACKERS] path toward faster partition pruning