Re: Log a sample of transactions

From: Christoph Berg <myon(at)debian(dot)org>
To: Adrien NAYRAT <adrien(dot)nayrat(at)anayrat(dot)info>
Cc: "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Log a sample of transactions
Date: 2019-03-28 09:45:10
Message-ID: 20190328094510.GD31223@msg.df7cb.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Re: Adrien NAYRAT 2019-03-28 <c86d676a-0b1e-f9be-3da2-63fa15070db0(at)anayrat(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dmitry Dolgov 2019-03-28 10:01:24 Re: Index Skip Scan
Previous Message Masahiko Sawada 2019-03-28 09:40:24 Re: Log a sample of transactions