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 1tDn7S-003DA0-1x for pgsql-hackers@arkaria.postgresql.org; Wed, 20 Nov 2024 15:59:54 +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 1tDn7Q-0074D5-OL for pgsql-hackers@arkaria.postgresql.org; Wed, 20 Nov 2024 15:59:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tDn7Q-0074Cm-Dh for pgsql-hackers@lists.postgresql.org; Wed, 20 Nov 2024 15:59:52 +0000 Received: from mail-io1-xd35.google.com ([2607:f8b0:4864:20::d35]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tDn7N-002wn4-Uz for pgsql-hackers@postgresql.org; Wed, 20 Nov 2024 15:59:51 +0000 Received: by mail-io1-xd35.google.com with SMTP id ca18e2360f4ac-83aae6aba1aso147294239f.2 for ; Wed, 20 Nov 2024 07:59:49 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1732118388; x=1732723188; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=k7M3G/1qKCIwf/miWNULCn8pGOQyt/kMoPJeax4pls8=; b=Xii8fInxdPJcpxOwMEdDMhDMeJ6MZ9IDecN+Lv/OzlaA6qi+OnmwPIZO64W9A8SVcE bZJFqjcGUEsPf7wjKxCmOf+7c+VuxRkWbsJtyFzcITlsI2GbC0E0wSZMRG3BLX9xronl z2uZqDpu6eK7ky1GZU3TS8qPr7oH/ghBXAV9YxSWPWhniRnOUZ8RIdfDU6G5QofdiChl ASJQA4bDUpCFbnPmn03Brhfi9fA2zUUT+vuXfIioBJj1uHtyeQZ7yPpNj+Bmhel/3/lI sSX84AjsIQYHdBIfCTl6tAdhvkISaE0XR9sj7pXMqQFZpky2zLIImpjCL4Bfe3Gt/eI/ XvFQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1732118388; x=1732723188; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=k7M3G/1qKCIwf/miWNULCn8pGOQyt/kMoPJeax4pls8=; b=Gk+bi4eYu06k1cmyg51+WEShdR8gpgD5LcB1L7K87V2gQf5/6O+vUZ9+jWC/KOg8CG SCNj+yAbNyOQUCoe70rQcuF1hqQE3yoq+qRoS2ghdCdDi7Th/9BHZhWZtOXeGL99K3HU CBZQrBc6zBo29AQKRLR1RRvRx7dTOb29fFSn2hI3tkzo2iuyaVbcSchT8xf+l3PETffC V5dHV28nk/UxOMSV9AP7jnJ9Vs0B1VSYXC2FJeVQu9kGRfmkJi/eNacwKiYJxUoL3Rg9 oDLvAPw1gvF57xfYq2ptYx5UN5PihmFGCTtD7p4wZgI1/Ida20FjXCm9MxCJaOkAWuCF 6+lA== X-Forwarded-Encrypted: i=1; AJvYcCXpYWWoFfQInPF3wZUJJjpWZhzNrwj+iN5z8JElKJKvOYU241jhHeimfJKOOXTsIVB6lZQy/1m6Anh3ZIMd@postgresql.org X-Gm-Message-State: AOJu0YxSIoImasXPph/5qMlnvrFggwS54xnwLWUW+0Pi1Iob1OjGQOB0 /vCrNFeb7eRm+NMWl0ZW5WSKgv6FnJVSSuNiOcC2lmsliQdWTN7Nd3i8ZeQDR2kIM+rFtbww6Tt ZINq5yurGDirRtiUA6Lf/Z9TXdqaiwy58 X-Google-Smtp-Source: AGHT+IGeeoBx8gHt98LxHv9qtYyDvTQJ43YgivCR6mTDoGF4H6raBM095hEl/M3wk+AJnyfGBcT7juuIkqyROC/dJeU= X-Received: by 2002:a05:6602:3d0:b0:82c:f30d:fc72 with SMTP id ca18e2360f4ac-83eb5f6b654mr407794739f.2.1732118388117; Wed, 20 Nov 2024 07:59:48 -0800 (PST) MIME-Version: 1.0 References: <6707FCA9-FD1A-4609-A1A6-142456C14E0C@yandex-team.ru> In-Reply-To: From: Greg Sabino Mullane Date: Wed, 20 Nov 2024 10:59:12 -0500 Message-ID: Subject: Re: Sample rate added to pg_stat_statements To: Michael Paquier Cc: "Andrey M. Borodin" , Ilia Evdokimov , pgsql-hackers Content-Type: multipart/alternative; boundary="0000000000003b9c4a06275a3d88" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000003b9c4a06275a3d88 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, Nov 19, 2024 at 5:07=E2=80=AFPM Michael Paquier wrote: > One piece of it would be to see how much of such "bottlenecks" we > would be able to get rid of by integrating pg_stat_statements into > the central pgstats with the custom APIs, without pushing the module > into core. Any particular reason these days we cannot push this into core and allow disabling on startup? To say this extension is widely used would be an understatement. Cheers, Greg --0000000000003b9c4a06275a3d88 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Tue, Nov 19, 2024 at 5:07=E2=80=AFPM M= ichael Paquier <michael@paquier.x= yz> wrote:
One piece of it would be to see how much of such &= quot;bottlenecks" we
would be able to get rid of by integrating pg_stat_statements into
the central pgstats with the custom APIs, without pushing the module
into core.

Any particular reason these days= we cannot push this into core and allow disabling on startup? To say this = extension is widely used would be an understatement.

Cheers,
Greg

--0000000000003b9c4a06275a3d88--