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-0001b9-9O@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_6_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/be87cd2a0aa02428084c83b59d10a2c033e0ae81

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/.