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
Ответ на
Re: About to add WAL write/fsync statistics to pg_stat_wal view (Masahiro Ikeda)
Список
Дерево обсуждения
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 по дате отправления