Re: Resetting spilled txn statistics in pg_stat_replication

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема Re: Resetting spilled txn statistics in pg_stat_replication
Дата
Msg-id CAA4eK1+_hmDGpjyM50knFeOZr1ZOvJJSiFRKfNbGDRds9MyHmA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Resetting spilled txn statistics in pg_stat_replication  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-hackers
On Tue, Oct 27, 2020 at 8:51 AM Justin Pryzby <pryzby@telsasoft.com> wrote:
>
> On Fri, Oct 23, 2020 at 10:45:34AM +0530, Amit Kapila wrote:
> > On Fri, Oct 23, 2020 at 8:59 AM Amit Kapila <amit.kapila16@gmail.com> wrote:
> >
> > While updating the streaming stats patch, it occurred to me that we
> > can write a better description spill_bytes as well. Attached contains
> > the update to spill_bytes description.
>
> +        This and other spill
> +        counters can be used to gauge the I/O occurred during logical decoding
> +        and accordingly can tune <literal>logical_decoding_work_mem</literal>.
>
> "gauge the IO occurred" is wrong.
> Either: I/O *which* occured, or I/O occurring, or occurs.
>
> "can tune" should say "allow tuning".
>
> Like:
> +        This and other spill
> +        counters can be used to gauge the I/O which occurs during logical decoding
> +        and accordingly allow tuning of <literal>logical_decoding_work_mem</literal>.
>
> -        Number of times transactions were spilled to disk. Transactions
> +        Number of times transactions were spilled to disk while performing
> +        decoding of changes from WAL for this slot. Transactions
>
> What about: "..while decoding changes.." (remove "performing" and "of").
>

All of your suggestions sound good to me. Find the patch attached to
update the docs accordingly.

-- 
With Regards,
Amit Kapila.

Вложения

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Patch to fix FK-related selectivity estimates with constants
Следующее
От: Nikolay Samokhvalov
Дата:
Сообщение: Re: Add important info about ANALYZE after create Functional Index