Re: About to add WAL write/fsync statistics to pg_stat_wal view

Поиск
Список
Период
Сортировка
Искать
От
Fujii Masao
Тема
Re: About to add WAL write/fsync statistics to pg_stat_wal view
Дата
Msg-id
f081d50f-f20d-8706-aba3-f59cddf7a949@oss.nttdata.com
Ответ на
Список
Дерево обсуждения
About to add WAL write/fsync statistics to pg_stat_wal view Masahiro Ikeda <ikedamsh@oss.nttdata.com>
Re: About to add WAL write/fsync statistics to pg_stat_wal view Li Japin <japinli@hotmail.com>
Re: About to add WAL write/fsync statistics to pg_stat_wal view Masahiro Ikeda <ikedamsh@oss.nttdata.com>
Re: About to add WAL write/fsync statistics to pg_stat_wal view Masahiro Ikeda <ikedamsh@oss.nttdata.com>
Re: About to add WAL write/fsync statistics to pg_stat_wal view Masahiko Sawada <sawada.mshk@gmail.com>
Re: About to add WAL write/fsync statistics to pg_stat_wal view Masahiro Ikeda <ikedamsh@oss.nttdata.com>
Re: About to add WAL write/fsync statistics to pg_stat_wal view Masahiko Sawada <sawada.mshk@gmail.com>
Re: About to add WAL write/fsync statistics to pg_stat_wal view Masahiro Ikeda <ikedamsh@oss.nttdata.com>
Re: About to add WAL write/fsync statistics to pg_stat_wal view Masahiro Ikeda <ikedamsh@oss.nttdata.com>
Re: About to add WAL write/fsync statistics to pg_stat_wal view Masahiko Sawada <sawada.mshk@gmail.com>
Re: About to add WAL write/fsync statistics to pg_stat_wal view Masahiro Ikeda <ikedamsh@oss.nttdata.com>
Re: About to add WAL write/fsync statistics to pg_stat_wal view Masahiko Sawada <sawada.mshk@gmail.com>
Re: About to add WAL write/fsync statistics to pg_stat_wal view Masahiro Ikeda <ikedamsh@oss.nttdata.com>
Re: About to add WAL write/fsync statistics to pg_stat_wal view "David G. Johnston" <david.g.johnston@gmail.com>
Re: About to add WAL write/fsync statistics to pg_stat_wal view "David G. Johnston" <david.g.johnston@gmail.com>
Re: About to add WAL write/fsync statistics to pg_stat_wal view Masahiro Ikeda <ikedamsh@oss.nttdata.com>
Re: About to add WAL write/fsync statistics to pg_stat_wal view "David G. Johnston" <david.g.johnston@gmail.com>
Re: About to add WAL write/fsync statistics to pg_stat_wal view Masahiro Ikeda <ikedamsh@oss.nttdata.com>
Re: About to add WAL write/fsync statistics to pg_stat_wal view Masahiro Ikeda <ikedamsh@oss.nttdata.com>
Re: About to add WAL write/fsync statistics to pg_stat_wal view "David G. Johnston" <david.g.johnston@gmail.com>
Re: About to add WAL write/fsync statistics to pg_stat_wal view Masahiro Ikeda <ikedamsh@oss.nttdata.com>
Re: About to add WAL write/fsync statistics to pg_stat_wal view Fujii Masao <masao.fujii@oss.nttdata.com>
Re: About to add WAL write/fsync statistics to pg_stat_wal view Masahiro Ikeda <ikedamsh@oss.nttdata.com>
Re: About to add WAL write/fsync statistics to pg_stat_wal view Fujii Masao <masao.fujii@oss.nttdata.com>
Re: About to add WAL write/fsync statistics to pg_stat_wal view Masahiro Ikeda <ikedamsh@oss.nttdata.com>
Re: About to add WAL write/fsync statistics to pg_stat_wal view japin <japinli@hotmail.com>
Re: About to add WAL write/fsync statistics to pg_stat_wal view Masahiro Ikeda <ikedamsh@oss.nttdata.com>
Re: About to add WAL write/fsync statistics to pg_stat_wal view japin <japinli@hotmail.com>
Re: About to add WAL write/fsync statistics to pg_stat_wal view Masahiro Ikeda <ikedamsh@oss.nttdata.com>
RE: About to add WAL write/fsync statistics to pg_stat_wal view "kuroda.hayato@fujitsu.com" <kuroda.hayato@fujitsu.com>
RE: About to add WAL write/fsync statistics to pg_stat_wal view Masahiro Ikeda <ikedamsh@oss.nttdata.com>
RE: About to add WAL write/fsync statistics to pg_stat_wal view "kuroda.hayato@fujitsu.com" <kuroda.hayato@fujitsu.com>
RE: About to add WAL write/fsync statistics to pg_stat_wal view "kuroda.hayato@fujitsu.com" <kuroda.hayato@fujitsu.com>
RE: About to add WAL write/fsync statistics to pg_stat_wal view Masahiro Ikeda <ikedamsh@oss.nttdata.com>


On 2021/02/05 8:45, Masahiro Ikeda wrote:
> I pgindented the patches.

Thanks for updating the patches!

+       XLogWrite, which nomally called by an
+       issue_xlog_fsync, which nomally called by an

Typo: "nomally" should be "normally"?

+       XLogFlush request(see )
+       XLogFlush request(see ),

Isn't it better to add a space character just after "request"?

+					INSTR_TIME_SET_CURRENT(duration);
+					INSTR_TIME_SUBTRACT(duration, start);
+					WalStats.m_wal_write_time = INSTR_TIME_GET_MICROSEC(duration);

If several cycles happen in the do-while loop, m_wal_write_time should be
updated with the sum of "duration" in those cycles instead of "duration"
in the last cycle? If yes, "+=" should be used instead of "=" when updating
m_wal_write_time?

+			INSTR_TIME_SET_CURRENT(duration);
+			INSTR_TIME_SUBTRACT(duration, start);
+			WalStats.m_wal_sync_time = INSTR_TIME_GET_MICROSEC(duration);

Also "=" should be "+=" in the above?

Regards,


-- 
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION


В списке pgsql-hackers по дате отправления
От: Amit Kapila
Дата:
От: Dilip Kumar
Дата:
FAQ