Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1epIOS-0001yx-7m for pgsql-bugs@arkaria.postgresql.org; Fri, 23 Feb 2018 18:48:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1epIOQ-0007Mx-0I for pgsql-bugs@arkaria.postgresql.org; Fri, 23 Feb 2018 18:48:26 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1epIOP-0007MV-6w for pgsql-bugs@lists.postgresql.org; Fri, 23 Feb 2018 18:48:25 +0000 Received: from gproxy4-pub.mail.unifiedlayer.com ([69.89.23.142]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1epIOG-0000Pv-6e for pgsql-bugs@lists.postgresql.org; Fri, 23 Feb 2018 18:48:24 +0000 Received: from cmgw2 (unknown [10.0.90.83]) by gproxy4.mail.unifiedlayer.com (Postfix) with ESMTP id 54AD51779E7 for ; Fri, 23 Feb 2018 11:34:30 -0700 (MST) Received: from box390.bluehost.com ([69.89.31.190]) by cmgw2 with id EJaS1x00R467Erp01JaVEo; Fri, 23 Feb 2018 11:34:30 -0700 X-Authority-Analysis: v=2.2 cv=M5g9E24s c=1 sm=1 tr=0 a=t6//4EQnHSbopLQ0OUmvgQ==:117 a=t6//4EQnHSbopLQ0OUmvgQ==:17 a=IkcTkHD0fZMA:10 a=Op4juWPpsa0A:10 a=Ye9q-bpsAAAA:8 a=dDIrZr6TOttbm3kosYgA:9 a=QEXdDO2ut3YA:10 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=codingthat.com; s=default; h=Content-Transfer-Encoding:Content-Type: MIME-Version:Date:Message-ID:Subject:From:To:Sender:Reply-To:Cc:Content-ID: Content-Description:Resent-Date:Resent-From:Resent-Sender:Resent-To:Resent-Cc :Resent-Message-ID:In-Reply-To:References:List-Id:List-Help:List-Unsubscribe: List-Subscribe:List-Post:List-Owner:List-Archive; bh=IIKZT0v/LWczCmQmc/GDWkq0qPkiHbgC+wkgy7Uiw/U=; b=XmVEjak4PHFGlfHQvsNWqs7715 33Px12ifWAyJnuKAH5VkjJKxnCdQhyl+MXZt6Gskin2XZHpwZAGDto0b+/ufYKiAk4D6beVODatTs Er3iGcEZLGT21DB3GaHIMCzrgVLZNUmrXYhQhvVNyIVkL7LnbfRoSU/F94G+woJ1cQVNSg+mcR5rp 4mrRMYQQqvR0DkWj6fCkICHVey8vZk6+wjDBrsbDD0Xf2ZYH1tDkAVdln4szPzxiNoj8H7qjqh7gY lnKoXYSpFCmnByOX7pgR/h9p3zaGEqC1tXidVfdLTbUvpRKsvSq7owtJ2I5Aj3fpSbfCOhJdiVReO l63RSpNg==; Received: from adsl-178-38-82-94.adslplus.ch ([178.38.82.94]:36134 helo=[192.168.178.87]) by box390.bluehost.com with esmtpsa (TLSv1.2:ECDHE-RSA-AES128-GCM-SHA256:128) (Exim 4.89_1) (envelope-from ) id 1epIAs-000WAZ-1a for pgsql-bugs@lists.postgresql.org; Fri, 23 Feb 2018 11:34:26 -0700 To: pgsql-bugs@lists.postgresql.org From: Kevin Bloch Subject: maximum for auto_explain.log_min_duration doesn't seem to make sense Message-ID: <8ea82d7e-cb78-8e05-0629-73aa14d2a0ca@codingthat.com> Date: Fri, 23 Feb 2018 19:34:22 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.5.0 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - box390.bluehost.com X-AntiAbuse: Original Domain - lists.postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - codingthat.com X-BWhitelist: no X-Source-IP: 178.38.82.94 X-Exim-ID: 1epIAs-000WAZ-1a X-Source: X-Source-Args: X-Source-Dir: X-Source-Sender: adsl-178-38-82-94.adslplus.ch ([192.168.178.87]) [178.38.82.94]:36134 X-Source-Auth: kev@codingthat.com X-Email-Count: 1 X-Source-Cap: Y29kaW5ndGg7Y29kaW5ndGg7Ym94MzkwLmJsdWVob3N0LmNvbQ== X-Local-Domain: yes List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk According to https://dba.stackexchange.com/a/198429/28774 , this setting maxes out at INT_MAX / 1000, but since it's never multiplied by 1000 or any other number, it seems it should perhaps just be INT_MAX . Cheers, Kev