RE: Re: Log a sample of transactions

Поиск
Список
Период
Сортировка
Искать
От
Kuroda, Hayato
Тема
RE: Re: Log a sample of transactions
Дата
Msg-id
1F66B161998C704BABF8989B8A2AC0A31CDD2C@G01JPEXMBYT05
Ответ на
Список
Дерево обсуждения
Log a sample of transactions Adrien Nayrat <adrien.nayrat@anayrat.info>
RE: Log a sample of transactions "Kuroda, Hayato" <kuroda.hayato@jp.fujitsu.com>
Re: Log a sample of transactions Adrien NAYRAT <adrien.nayrat@anayrat.info>
RE: Log a sample of transactions "Kuroda, Hayato" <kuroda.hayato@jp.fujitsu.com>
Re: Log a sample of transactions Adrien NAYRAT <adrien.nayrat@anayrat.info>
RE: Log a sample of transactions "Kuroda, Hayato" <kuroda.hayato@jp.fujitsu.com>
Re: Log a sample of transactions Adrien NAYRAT <adrien.nayrat@anayrat.info>
RE: Log a sample of transactions "Kuroda, Hayato" <kuroda.hayato@jp.fujitsu.com>
Re: Log a sample of transactions Adrien Nayrat <adrien.nayrat@anayrat.info>
Re: Log a sample of transactions Michael Paquier <michael@paquier.xyz>
Re: Log a sample of transactions Adrien NAYRAT <adrien.nayrat@anayrat.info>
Re: Log a sample of transactions Michael Paquier <michael@paquier.xyz>
Re: Log a sample of transactions Andres Freund <andres@anarazel.de>
Re: Log a sample of transactions Adrien NAYRAT <adrien.nayrat@anayrat.info>
Re: Log a sample of transactions Adrien NAYRAT <adrien.nayrat@anayrat.info>
Re: Re: Log a sample of transactions David Steele <david@pgmasters.net>
RE: Re: Log a sample of transactions "Kuroda, Hayato" <kuroda.hayato@jp.fujitsu.com>
Re: Log a sample of transactions Adrien NAYRAT <adrien.nayrat@anayrat.info>
RE: Log a sample of transactions "Kuroda, Hayato" <kuroda.hayato@jp.fujitsu.com>
Re: Log a sample of transactions Adrien NAYRAT <adrien.nayrat@anayrat.info>
Re: Log a sample of transactions Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Log a sample of transactions Adrien NAYRAT <adrien.nayrat@anayrat.info>
Re: Log a sample of transactions Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Log a sample of transactions Adrien Mobile <adrien.nayrat@anayrat.info>
Re: Log a sample of transactions Masahiko Sawada <sawada.mshk@gmail.com>
Re: Log a sample of transactions Adrien NAYRAT <adrien.nayrat@anayrat.info>
Re: Log a sample of transactions Michael Paquier <michael@paquier.xyz>
Re: Log a sample of transactions Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Log a sample of transactions Adrien NAYRAT <adrien.nayrat@anayrat.info>
Re: Log a sample of transactions Robert Haas <robertmhaas@gmail.com>
Re: Log a sample of transactions Masahiko Sawada <sawada.mshk@gmail.com>
Re: Log a sample of transactions Adrien NAYRAT <adrien.nayrat@anayrat.info>
Dear David,

I have a will and already read the patch, but I thought it's not my turn.
Sorry.


Adrien,

>  I did not find any test for log_min_duration that could help me. LCOV indicate
> there is no tests on this part (look check_log_duration()):
> https://coverage.postgresql.org/src/backend/tcop/postgres.c.gcov.html

I understand the unnecessarily of some test case. It's OK.

Finally, how do you think about the deviation of randomness?
If this parameter is set very low, nobody may be output because of the deviation.
we can avoid this phenomenon by counting up internal parameter for each transactions and output to log file if the parameter becomes  more than 1.

After consideration for this case and rebasing, I think this patch is enough.
Do I have to measure the change of throughput?


Best Regards,
Hayato Kuroda
Fujitsu LIMITED


В списке pgsql-hackers по дате отправления
От: Andres Freund
Дата:
Сообщение: setLastTid() and currtid()
От: Tatsuro Yamada
Дата:
FAQ