Re: Resetting spilled txn statistics in pg_stat_replication

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема Re: Resetting spilled txn statistics in pg_stat_replication
Дата
Msg-id CAA4eK1+F5yRdE0WwMPf5y4Pb2jKWbxRXvHokf=8P=rvw_LNb9w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Resetting spilled txn statistics in pg_stat_replication  (Masahiko Sawada <masahiko.sawada@2ndquadrant.com>)
Ответы Re: Resetting spilled txn statistics in pg_stat_replication  (Amit Kapila <amit.kapila16@gmail.com>)
Re: Resetting spilled txn statistics in pg_stat_replication  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Tue, Oct 13, 2020 at 4:54 AM Masahiko Sawada
<masahiko.sawada@2ndquadrant.com> wrote:
>
> Attached the updated version patch. Please review it.
>

I have pushed this but it failed in one of the BF. See
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=florican&dt=2020-10-13%2003%3A07%3A25

The failure is shown below and I am analyzing it. See, if you can
provide any insights.

@@ -58,7 +58,7 @@
 SELECT name, spill_txns, spill_count FROM pg_stat_replication_slots;
       name       | spill_txns | spill_count
 -----------------+------------+-------------
- regression_slot |          1 |          12
+ regression_slot |          1 |          10
 (1 row)

 -- reset the slot stats, and wait for stats collector to reset
@@ -96,7 +96,7 @@
 SELECT name, spill_txns, spill_count FROM pg_stat_replication_slots;
       name       | spill_txns | spill_count
 -----------------+------------+-------------
- regression_slot |          1 |          12
+ regression_slot |          1 |          10
 (1 row)



-- 
With Regards,
Amit Kapila.



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

Предыдущее
От: Masahiro Ikeda
Дата:
Сообщение: Re: New statistics for tuning WAL buffer size
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Resetting spilled txn statistics in pg_stat_replication