Re: Log a sample of transactions

Поиск
Список
Период
Сортировка
От Christoph Berg
Тема Re: Log a sample of transactions
Дата
Msg-id 20190328094510.GD31223@msg.df7cb.de
обсуждение исходный текст
Ответ на Re: Log a sample of transactions  (Adrien NAYRAT <adrien.nayrat@anayrat.info>)
Ответы Re: Log a sample of transactions
Список pgsql-hackers
Re: Adrien NAYRAT 2019-03-28 <c86d676a-0b1e-f9be-3da2-63fa15070db0@anayrat.info>
> > > > Sorry, I changed that, someone suggest using either "0" and "1", or
> > > > "0.0" and "1.0" but not mixing both.
> > 
> > Agreed with using "0.0" and "1.0".
> > 
> > > > I will remove this change.

> +#log_transaction_sample_rate = 0    # Fraction of transactions whose statements
> +                    # are logged regardless of their duration. 1.0 logs all
> +                    # statements from all transactions, 0.0 never logs.

This still looks weird to me. If the default is to never log, and
that's 0.0 as per the comment, the setting should be 0.0 as well.


The same applies to log_statement_sample_rate which is already
committed, were it looks even worse:

#log_statement_sample_rate = 1  # Fraction of logged statements over
                                        # log_min_duration_statement. 1.0 logs all statements,
                                        # 0 never logs.

Is "over" even correct English? ("out of" "from"?)

Christoph



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

Предыдущее
От: Masahiko Sawada
Дата:
Сообщение: Re: Log a sample of transactions
Следующее
От: Dmitry Dolgov
Дата:
Сообщение: Re: Index Skip Scan