Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oc5oZ-0005WQ-G6 for pgsql-hackers@arkaria.postgresql.org; Sat, 24 Sep 2022 14:07:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oc5oW-0001xt-M2 for pgsql-hackers@arkaria.postgresql.org; Sat, 24 Sep 2022 14:07:28 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from <9erthalion6@gmail.com>) id 1oc5oW-0001wn-AT for pgsql-hackers@lists.postgresql.org; Sat, 24 Sep 2022 14:07:28 +0000 Received: from mail-ej1-x62c.google.com ([2a00:1450:4864:20::62c]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from <9erthalion6@gmail.com>) id 1oc5oP-0003MF-OU for pgsql-hackers@postgresql.org; Sat, 24 Sep 2022 14:07:27 +0000 Received: by mail-ej1-x62c.google.com with SMTP id y3so5924722ejc.1 for ; Sat, 24 Sep 2022 07:07:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date; bh=o2xhRCn+YLWSQNBmCWy9XZXwz63oRvF8lVwq4fldgSM=; b=N3ym7ES+pXWJaLPu/AaA4G0T92GhEzTdVvGj1EGZlV4KunhnXeo9rMclE2FNnGUMpV zsA1yrZ+qpduKV4OIjTcTMAaCIIm2nvW2z78/KK6SjXF/6ackx3BpfxDuwJTJuUdgc2T Nhp9AUd1rwRz/RzdB0GmMogyePsGwhAXL6+5gvk0QaQpCnkCtKXfDubNI1joImbTP8Xt nEs8z/jqjOVUZZOYY+zWK4WRZcXrDBcs6RFJxBPWxSLw1SE0yRLNjz6QgQlmmnkubIXX vQmvvfRU9h7i3QtMpA9JjwYPXAW/BP7NpucHIrLLebmtpBKmZCbow0boGUkHXoxdahT0 L6mA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date; bh=o2xhRCn+YLWSQNBmCWy9XZXwz63oRvF8lVwq4fldgSM=; b=aOaj7fg9hFxVxJ5JNtray6WpI7wLU2EDwdeAudrYATlIx65U3s9JZRw6x+/DSl06OI F9Xy7XtfPCNnx6s6Rr5C1usEZny2Vre/pbZ4MbIM7K2Df34btYypYTTDpLkLQS8Wmxmp xQrGS78z1iJPnJPDyUFYb/K79173K8TZHpxJVhfdwKa0NO4L8AJ/dxs5mlmswcq9kPM7 /YnvRnzTzgvD6+mC8lF2dRXyvsRlmjYThEEKQzi1rwM4gWgEuZ1eFqhPNC0pbUhyLQ/o i96RY1GSzwnK18lHRYdgbiNkT0wePHLY3vYeuwRVIC1WumGkOqWgyDHkit8HEuVYPVGm lEJQ== X-Gm-Message-State: ACrzQf1agEJ1Iic/6v06gTEVQUAw/pRqSkzQ5wNNMUBQyCje8yKP/CTJ edgIr6JzBN6KhrsMd6o7+24= X-Google-Smtp-Source: AMsMyM5JkKGEt9I+7nEsij4JY5PPyIGn0cUAmKjZ1W81H/ZIaV1V4YJLXeMI1rjkljWAPEGXIGOR5w== X-Received: by 2002:a17:907:2c4b:b0:77e:2c09:4111 with SMTP id hf11-20020a1709072c4b00b0077e2c094111mr11674034ejc.21.1664028439478; Sat, 24 Sep 2022 07:07:19 -0700 (PDT) Received: from ddolgov.remote.csb (068-188-119-174.biz.spectrum.com. [68.188.119.174]) by smtp.gmail.com with ESMTPSA id 25-20020a170906319900b0073ae9ba9ba8sm5563036ejy.3.2022.09.24.07.07.16 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sat, 24 Sep 2022 07:07:18 -0700 (PDT) Date: Sat, 24 Sep 2022 16:07:14 +0200 From: Dmitry Dolgov <9erthalion6@gmail.com> To: Sergei Kornilov Cc: Robert Haas , Zhihong Yu , David Steele , PostgreSQL-development , Greg Stark , Pavel Trukhanov , Tom Lane Subject: Re: pg_stat_statements and "IN" conditions Message-ID: <20220924140714.irgoytcu2wacdl2i@ddolgov.remote.csb> References: <20220314145734.x3re4hcr6ukmppwi@ddolgov.remote.csb> <178940.1647271397@sss.pgh.pa.us> <20220314153346.6chynq26mcypxaco@ddolgov.remote.csb> <180607.1647272303@sss.pgh.pa.us> <20220314155150.mgitoto7e5jkqilb@ddolgov.remote.csb> <20220326174035.2vwhtof6ow7kib7n@erthalion.local> <20220724100636.do3nt7f73d7zbrfx@erthalion.local> <2709541663352713@prvcgftslwhsg7ig.myt.yp-c.yandex.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <2709541663352713@prvcgftslwhsg7ig.myt.yp-c.yandex.net> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Fri, Sep 16, 2022 at 09:25:13PM +0300, Sergei Kornilov wrote: > Hello! > > Unfortunately the patch needs another rebase due to the recent split of guc.c (0a20ff54f5e66158930d5328f89f087d4e9ab400) > > I'm reviewing a patch on top of a previous commit and noticed a failed test: > > # Failed test 'no parameters missing from postgresql.conf.sample' > # at t/003_check_guc.pl line 82. > # got: '1' > # expected: '0' > # Looks like you failed 1 test of 3. > t/003_check_guc.pl .............. > > The new option has not been added to the postgresql.conf.sample > > PS: I would also like to have such a feature. It's hard to increase pg_stat_statements.max or lose some entries just because some ORM sends requests with a different number of parameters. Thanks! I'll post the rebased version soon.