pgsql: Allow auto_explain.log_min_duration to go up to INT_MAX.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Allow auto_explain.log_min_duration to go up to INT_MAX.
Date: 2018-02-23 19:39:42
Message-ID: E1epJC2-0001bB-9E@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Allow auto_explain.log_min_duration to go up to INT_MAX.

The previous limit of INT_MAX / 1000 seems to have been cargo-culted in
from somewhere else. Or possibly the value was converted to microseconds
at some point; but in all supported releases, it's just compared to other
values, so there's no need for the restriction. This change raises the
effective limit from ~35 minutes to ~24 days, which conceivably is useful
to somebody, and anyway it's more consistent with the range of the core
log_min_duration_statement GUC.

Per complaint from Kevin Bloch. Back-patch to all supported releases.

Discussion: https://postgr.es/m/8ea82d7e-cb78-8e05-0629-73aa14d2a0ca@codingthat.com

Branch
------
REL9_5_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/753875ed42fd3f854933684c5f8f7358b1a16172

Modified Files
--------------
contrib/auto_explain/auto_explain.c | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2018-02-23 20:11:46 pgsql: Fix brown-paper-bag bug in commit 0a459cec96d3856f476c2db298c6b5
Previous Message Noah Misch 2018-02-23 19:32:37 pgsql: Synchronize doc/ copies of src/test/examples/.