pgsql: Add log_statement_sample_rate parameter

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add log_statement_sample_rate parameter
Date: 2018-11-29 21:43:22
Message-ID: E1gSU5i-0006Zf-Gl@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add log_statement_sample_rate parameter

This allows to set a lower log_min_duration_statement value without
incurring excessive log traffic (which reduces performance). This can
be useful to analyze workloads with lots of short queries.

Author: Adrien Nayrat
Reviewed-by: David Rowley, Vik Fearing
Discussion: https://postgr.es/m/c30ee535-ee1e-db9f-fa97-146b9f62caed@anayrat.info

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/88bdbd3f746049834ae3cc972e6e650586ec3c9d

Modified Files
--------------
doc/src/sgml/config.sgml | 30 ++++++++++++++++++++++-----
src/backend/tcop/postgres.c | 16 ++++++++++++--
src/backend/utils/misc/guc.c | 15 +++++++++++++-
src/backend/utils/misc/postgresql.conf.sample | 13 +++++++-----
src/include/utils/guc.h | 1 +
5 files changed, 62 insertions(+), 13 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2018-11-29 23:28:30 pgsql: Document handling of invalid/ambiguous timestamp input near DST
Previous Message Tom Lane 2018-11-29 20:54:00 pgsql: Ensure static libraries have correct mod time even if ranlib mes