Re: Replication slot stats misgivings

Поиск
Список
Период
Сортировка
От Masahiko Sawada
Тема Re: Replication slot stats misgivings
Дата
Msg-id CAD21AoB74CAcNOp8nD3VFKdJQ5wkSJnKCLikowGp+RTV9N0t8w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Replication slot stats misgivings  (Andres Freund <andres@anarazel.de>)
Ответы Re: Replication slot stats misgivings
Список pgsql-hackers
On Tue, Mar 30, 2021 at 9:58 AM Andres Freund <andres@anarazel.de> wrote:
>
> IMO, independent of the shutdown / startup issue, it'd be worth writing
> a patch tracking the bytes sent independently of the slot stats storage
> issues. That would also make the testing for the above cheaper...

Agreed.

I think the bytes sent should be recorded by the decoding plugin, not
by the core side. Given that table filtering and row filtering,
tracking the bytes passed to the decoding plugin would not help gauge
the actual network I/O. In that sense, the description of stream_bytes
in the doc seems not accurate:

---
This and other streaming counters for this slot can be used to gauge
the network I/O which occurred during logical decoding and allow
tuning logical_decoding_work_mem.
---

It can surely be used to allow tuning logical_decoding_work_mem but it
could not be true for gauging the network I/O which occurred during
logical decoding.

Regards,

-- 
Masahiko Sawada
EDB:  https://www.enterprisedb.com/



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

Предыдущее
От: Bharath Rupireddy
Дата:
Сообщение: Re: Add client connection check during the execution of the query
Следующее
От: "'alvherre@alvh.no-ip.org'"
Дата:
Сообщение: Re: libpq debug log