Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qbMAv-00Bo5a-MW for pgsql-hackers@arkaria.postgresql.org; Wed, 30 Aug 2023 14:28:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qbMAu-0000Ul-DA for pgsql-hackers@arkaria.postgresql.org; Wed, 30 Aug 2023 14:28:04 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qbMAu-0000Ti-1n for pgsql-hackers@lists.postgresql.org; Wed, 30 Aug 2023 14:28:03 +0000 Received: from mail-ot1-x32e.google.com ([2607:f8b0:4864:20::32e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qbMAp-001nW3-Hr for pgsql-hackers@postgresql.org; Wed, 30 Aug 2023 14:28:02 +0000 Received: by mail-ot1-x32e.google.com with SMTP id 46e09a7af769-6bc9811558cso4095343a34.0 for ; Wed, 30 Aug 2023 07:27:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1693405679; x=1694010479; darn=postgresql.org; 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=Tb07pU4zIzWMe08hI/RzlCeSgFVR2izkSgYDt8nGPcY=; b=la/Z/ps0ggdhQzKJI3zyuiTFRBPQtralrw7FZ1uG6E+8lz8m3ZM/2rOUxiFHz3Y/j2 VPF5mcZC1oymsJ6KkawdUaFOSWpiPLxz/3kvIvSWoRBVlq0gy7EdUA2MQmNLfk4NgyI6 dsVeDU3n/Z9htRW8O0mp/usqCNjZlN+TdQgLtb/4dBPB5RAyLTcMwhpIEJSkqaBTZKfW vUsVsez1pW2As2aRB+HUFq+dPp3h0DqlXNJLtGKc+vKz9QWLXvSJX9M55DhMj9Utk9ky btZVBtR5mTngLe47195koWU3eFDh+BWAqQD41i6ylfHIZxmPP82KLIa88b01v5tAtJdq AXRg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1693405679; x=1694010479; 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=Tb07pU4zIzWMe08hI/RzlCeSgFVR2izkSgYDt8nGPcY=; b=SDDuVend6MFZPp1UQT4pc4wVoTyxJ1gPEWoZFUZj8MR9YUBIufEpxXmkNsp27Grq+2 OBFxhiXjzP1m4PMm+5l4LdawvTExt4UDqtuGkb0znOM2ru+YlrJ/6VaneWQbE2HTWrSY QNqQSlekJwjvuFig3QGUTC0ae00tKoXBJ9qyMuIk2j7CdoWXFC1CoB/vks4/arFxoSxJ E+NDAKo5uUu8+sDIbLja8H1pjwlrUMoazxwV8g3tgaA6Ep9KqnTWWZlXfAgVk7O6nMNS eqUn+ShaUF4ChwbFkqzazb7KPWDtvvSASzm7qG8eUG1/u65UqAKuZH83G5OeVvBrDy1A KZlA== X-Gm-Message-State: AOJu0YxzemFFRYVLKWU57Udlgzcr8Rnd0dpyZPHqRfl8Pn3uSb/Pu49Y PYhXcj5YCV/NEKZp0vYMA9Q= X-Google-Smtp-Source: AGHT+IGfsYALmUDVjH02qKAYpi0jTTw+aCmNWo+Qzf41D5+q6NJa2lpcL5A4AGmJ3kuYeNSND+bNWg== X-Received: by 2002:a05:6830:13cc:b0:6bf:17d2:9cd1 with SMTP id e12-20020a05683013cc00b006bf17d29cd1mr2646338otq.8.1693405678751; Wed, 30 Aug 2023 07:27:58 -0700 (PDT) Received: from nathanxps13 ([2600:1700:48f8:340f:1161:2af0:7c78:7f16]) by smtp.gmail.com with ESMTPSA id h8-20020a9d6408000000b006b96a4287d4sm5554624otl.5.2023.08.30.07.27.57 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 30 Aug 2023 07:27:58 -0700 (PDT) Date: Wed, 30 Aug 2023 07:27:55 -0700 From: Nathan Bossart To: Robert Haas Cc: Michael Paquier , "Imseih (AWS), Sami" , Ian Lawrence Barwick , pgsql-hackers Subject: Re: pg_stat_get_backend_subxact() and backend IDs? Message-ID: <20230830142755.GA2532838@nathanxps13> References: <20230825153251.GA1593219@nathanxps13> <20230825192949.GA1917227@nathanxps13> <20230829164655.GA2138073@nathanxps13> <20230830020151.GA2488217@nathanxps13> 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 Wed, Aug 30, 2023 at 09:50:41AM -0400, Robert Haas wrote: > Sorry, I'm only just noticing this thread. Thanks, Nathan, Ian, and > others, for your work on this. Apart from hoping that the 0002 patch > will get a more detailed commit message spelling out the problem very > explicitly, I don't have any comments on the proposed patches. I'm about to spend way too much time writing the commit message for 0002, but I plan to commit both patches sometime today. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com