Re: Logical replication wal sender timestamp bug

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Logical replication wal sender timestamp bug
Дата
Msg-id CAMkU=1w1NgTcJ8=L75w2MJDM63n5POqXo_9-qPN94+752e+6Ow@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Logical replication wal sender timestamp bug  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers


On Wed, Nov 6, 2019 at 2:15 AM Michael Paquier <michael@paquier.xyz> wrote:
On Tue, Nov 05, 2019 at 01:19:37PM +0900, Michael Paquier wrote:
> On Sat, Nov 02, 2019 at 09:54:54PM -0400, Jeff Janes wrote:
>> Filling out the timestamp after the message has already been sent is taking
>> "as late as possible" a little too far.  It results in every message having
>> a zero timestamp, other than keep-alives which go through a different path.
>
> It seems to me that you are right: the timestamp is computed too
> late.

It is easy enough to reproduce the problem by setting for example
logical replication between two nodes and pgbench to produce some
load and then monitor pg_stat_subscription periodically.  However, it
is a problem since logical decoding has been introduced (5a991ef) so
committed your fix down to 9.4.

Thanks.  This column looks much more reasonable now.

Cheers,

Jeff

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

Предыдущее
От: Ashwin Agrawal
Дата:
Сообщение: Re: Remove HeapTuple and Buffer dependency for predicate locking functions
Следующее
От: Andres Freund
Дата:
Сообщение: Re: heapam_index_build_range_scan's anyvisible