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 1tDPOe-000V6Z-Rn for pgsql-hackers@arkaria.postgresql.org; Tue, 19 Nov 2024 14:40:04 +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 1tDPOd-00Dlog-4D for pgsql-hackers@arkaria.postgresql.org; Tue, 19 Nov 2024 14:40:03 +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 1tDPOc-00DloX-NU for pgsql-hackers@lists.postgresql.org; Tue, 19 Nov 2024 14:40:02 +0000 Received: from mail-il1-x12c.google.com ([2607:f8b0:4864:20::12c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tDPOa-002i0x-49 for pgsql-hackers@postgresql.org; Tue, 19 Nov 2024 14:40:01 +0000 Received: by mail-il1-x12c.google.com with SMTP id e9e14a558f8ab-3a752be9f4bso11972835ab.2 for ; Tue, 19 Nov 2024 06:40:00 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1732027199; x=1732631999; 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=2+XER0GZMHVKE2FmuA3lDb0gsASQOXD1Pm+E6NCt8VQ=; b=MdjWXGO3YeMGrgX/CwiwTr0EB/CnPyEpgU6YPqrJsjiNExY1/wcXflDKpNIizT67yn jE/1wj1x6zs7dwTNVYgK1OJHwOREHLHWCyKF51UjPesWt+ATWKF8dtVPiURC3HCnDZCI GeFzaSVb7J/08eUw0715xw35MZ0ijjLSwt+JN37IpRilvCV1dJujA4Ho0eJsr10Mz3Kr CGJvYFqU0wV7XK2lIX013dB6KssTnojL2GJqcolW6j94zCoK6k0ia2XPTettH1ukgXQY hxZuOgtPFjNiAndl/ykk5Om3iLJ7y14ZGj1wwqXWpLi5mpSFSqysAYkpVl29yTYwtpqK 3nDw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1732027199; x=1732631999; 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=2+XER0GZMHVKE2FmuA3lDb0gsASQOXD1Pm+E6NCt8VQ=; b=k8uKuz3RHIlEjfGjCAftnuH3uDYQYBKSpRoY7aGZMw6PJqIF3tZUBgU4nrs9DhCoTp Z3wCBh+fZ/6bgzs2JGxXvUa+mDMId3clL/n41WjbNZaVNZMy4UzcCE91DM70rPgMfdQW fe18XqdQ/ncc8bd+xcfiD06OztONRz/5Sbjfx+5g8bPrGYg7+wL+Yn1nZ1zF8n/BbSb5 F+7czZ6Bp8uDTu/PrQF5/XJZYtkDy9jqpjbuJh3YDY0ZauK/MCxI45xUpef46oh2Nw7I k+n9It8LSlXMNzA7L8n94yR93B14mof2jFOcbVYfKmfP8rXdOzh4QrFSGP8wxv12YqsX XBDQ== X-Forwarded-Encrypted: i=1; AJvYcCViD+qnY/tlYhePdzvIQ6tDAGIoZAuU4Q/tQkFayTYGngC5fTp+eOkUWgt71gZbpvUB926Dw9z85lvqJzlS@postgresql.org X-Gm-Message-State: AOJu0YxwXECYDl3LLlX2eiqclbhoUsqFge7jsPzbh64OnV7BZicJbsYe T+HR52/u4YwH89B8jzes0lNt7QYJ/LZ9rroq+Q8FVUNoIw1UwRD4Fp6wESbyeQOVozfw8J+q8Cn UQ1gtin6nQAsoCktZys5QcQSLF+I2RA== X-Google-Smtp-Source: AGHT+IF28QM6hdj/4UHZX3eeMD5wpgmXxj+Dq5uBXpUdnu0Lugmt/7WKB1mzad01A6QxPIxQR3O0jHoKa+nHcerow08= X-Received: by 2002:a05:6e02:3083:b0:3a5:d2a:10e0 with SMTP id e9e14a558f8ab-3a748002e1bmr183706645ab.5.1732027198749; Tue, 19 Nov 2024 06:39:58 -0800 (PST) MIME-Version: 1.0 References: <6707FCA9-FD1A-4609-A1A6-142456C14E0C@yandex-team.ru> In-Reply-To: <6707FCA9-FD1A-4609-A1A6-142456C14E0C@yandex-team.ru> From: Greg Sabino Mullane Date: Tue, 19 Nov 2024 09:39:21 -0500 Message-ID: Subject: Re: Sample rate added to pg_stat_statements To: "Andrey M. Borodin" Cc: Ilia Evdokimov , pgsql-hackers Content-Type: multipart/alternative; boundary="000000000000ec48590627450182" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000ec48590627450182 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, Nov 19, 2024 at 7:12=E2=80=AFAM Andrey M. Borodin wrote: > +1 for the idea. I heard a lot of complaints about that pgss is costly. > Most of them were using it wrong though. I'm curious what "using it wrong" means exactly? Oh, and a +1 in general to the patch, OP, although it would also be nice to start finding the bottlenecks that cause such performance issues. Cheers, Greg --000000000000ec48590627450182 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Tue, Nov 19, 2024 at 7:12=E2=80=AFAM A= ndrey M. Borodin <x4mmm@yandex-t= eam.ru> wrote:
+1 for the idea. I heard a lot of complaints a= bout that pgss is costly. Most of them were using it wrong though.

I'm curious what "using it wrong" mea= ns exactly?

Oh, and a=C2=A0+1 in general to the pa= tch, OP, although it would also be nice to start finding the bottlenecks th= at cause such performance issues.

Cheers,
Greg

--000000000000ec48590627450182--