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 1pc9yk-0002pz-JF for pgsql-hackers@arkaria.postgresql.org; Tue, 14 Mar 2023 19:06:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pc9yj-0002hH-Ap for pgsql-hackers@arkaria.postgresql.org; Tue, 14 Mar 2023 19:06:33 +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 1pc9yj-0002h8-0n for pgsql-hackers@lists.postgresql.org; Tue, 14 Mar 2023 19:06:33 +0000 Received: from mail-ed1-x531.google.com ([2a00:1450:4864:20::531]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from <9erthalion6@gmail.com>) id 1pc9yg-0004EK-Cl for pgsql-hackers@postgresql.org; Tue, 14 Mar 2023 19:06:31 +0000 Received: by mail-ed1-x531.google.com with SMTP id fd5so32338049edb.7 for ; Tue, 14 Mar 2023 12:06:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; t=1678820788; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=khddlCuKc+NGr7ymNBipUP9L3UmH/fUPkwLMDG4M5p4=; b=pLYqTmbpUi7j9olUJYkucR2P3QIH+8X3Ys9Zy6/4zrRzHdbeTN8+X4fQqEaza3jctu nrXvZtYFPhSYwsmV8L9PrV8c5nufyLtC+y+4KythgbCLNggU2LtqrL1A1OQ5B9JsenHm iO65M8XmBr3EKhjmpph3OnggcHG1LvNEgvAhpoD0Q2eAF2lsA83PSU+8cSmlzVMsAYn0 J7Wy07ZBm6karh7W0jWcI5b9+Igf3BEzVd0InCXZFjCOuOnQHJyfUL8q2AtUr7VY0UTo HL+G5Gg3LYAj5zEgh65drxVL4Z8YqAsru2MAyXX3kbgisg0vI4lIM2bzwdcLQK32oJ0q LcXg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1678820788; 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 :message-id:reply-to; bh=khddlCuKc+NGr7ymNBipUP9L3UmH/fUPkwLMDG4M5p4=; b=eOj00vLBBksqhyUouRpl3Sg8tb6VrKtw8/LO8jy1QH/FF4co2tuZDU5Dj1VJdhzMPs hE4HPHuI0DwGDlWstF+pdwsbMkpGiDdGii+obvBs8jfaSR/ztg8QLVecXgCsdQ1HL1mc h+B5bzxMRRQ/EwAJ+EDY6WyFTMu0bvgPv1YxmamOMlsAlqblIc8M20kRHkHHOPhrdr2l UWRnnJHPPp7bV8HpAXQoTnM4dP1uFONAAwS4h0OO55DgL8uwfYuAGT26ha0b/1nx5npT LYDuYaTuW+VCS1KNOiiDvBSdjqUjz33tbUMWggAclTTjhDA1qBWfsvZ5aC6rZgpATdx5 tj0A== X-Gm-Message-State: AO0yUKVPsjkRvasLYFbNDSUatPHyCNzH9tM5tt+fbh4dGgynxu32TSL+ 7OQ50WbbtCoovTdU6w1md/Y= X-Google-Smtp-Source: AK7set9750kwtMjgIfIrjBzbfB5PK+xHImwv2WR/RvHppqEd5TN4etN9LUTjRw3VwNjvhR/Lb7pIpQ== X-Received: by 2002:aa7:d402:0:b0:4fc:3cd1:37c8 with SMTP id z2-20020aa7d402000000b004fc3cd137c8mr136109edq.22.1678820788150; Tue, 14 Mar 2023 12:06:28 -0700 (PDT) Received: from erthalion.local (dslb-178-012-042-178.178.012.pools.vodafone-ip.de. [178.12.42.178]) by smtp.gmail.com with ESMTPSA id w20-20020a50d794000000b004fb30fc1dabsm1448765edi.96.2023.03.14.12.06.26 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 14 Mar 2023 12:06:27 -0700 (PDT) Date: Tue, 14 Mar 2023 20:04:32 +0100 From: Dmitry Dolgov <9erthalion6@gmail.com> To: "Gregory Stark (as CFM)" Cc: David Geier , Sergei Kornilov , Michael Paquier , Alvaro Herrera , Marcos Pegoraro , vignesh C , Robert Haas , Zhihong Yu , David Steele , PostgreSQL-development , Pavel Trukhanov , Tom Lane Subject: Re: pg_stat_statements and "IN" conditions Message-ID: <20230314190432.l4oe3wa3pvt5b7hx@erthalion.local> References: <966631675800892@znolar4klagewshm.sas.yp-c.yandex.net> <20230209150238.rdtwruh5i34hdag5@ddolgov.remote.csb> <20230211104707.grsicemegr7d3mgh@erthalion.local> <20230211120820.y7krq37jubnjsa5b@erthalion.local> <07919318-6c35-a13f-6a1d-98686a3e38de@gmail.com> <20230217154602.uf3a3cgqeoeysycz@erthalion.local> <8702fa3e-5aac-dcf0-161b-faa2b9eadad6@gmail.com> <20230226104619.jfmwrpd5zrkmp3eu@erthalion.local> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Tue, Mar 14, 2023 at 02:14:17PM -0400, Gregory Stark (as CFM) wrote: > So I was seeing that this patch needs a rebase according to cfbot. Yeah, folks are getting up to speed in with pgss improvements recently. Thanks for letting me know. > However it looks like the review feedback you're looking for is more > of design questions. What jumbling is best to include in the feature > set and which is best to add in later patches. It sounds like you've > gotten conflicting feedback from initial reviews. > > It does sound like the patch is pretty mature and you're actively > responding to feedback so if you got more authoritative feedback it > might even be committable now. It's already been two years of being > rolled forward so it would be a shame to keep rolling it forward. You got it about right. There is a balance to strike between implementation, that would cover more useful cases, but has more dependencies (something like possibility of having multiple query id), and more minimalistic implementation that would actually be acceptable in the way it is now. But I haven't heard back from David about it, so I assume everybody is fine with the minimalistic approach. > Or is there some fatal problem that you're trying to work around and > still haven't found the magic combination that convinces any > committers this is something we want? In which case perhaps we set > this patch returned? I don't get that impression myself though. Nothing like this on my side, although I'm not good at conjuring committing powers of the nature.