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.96) (envelope-from ) id 1wQaxr-001fZy-1U for pgsql-hackers@arkaria.postgresql.org; Sat, 23 May 2026 01:15:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wQaxp-00F4CT-1G for pgsql-hackers@arkaria.postgresql.org; Sat, 23 May 2026 01:15:42 +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.96) (envelope-from ) id 1wQaxp-00F4CK-0G for pgsql-hackers@lists.postgresql.org; Sat, 23 May 2026 01:15:42 +0000 Received: from mail-qv1-xf2c.google.com ([2607:f8b0:4864:20::f2c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wQaxn-00000000yRw-3GSY for pgsql-hackers@postgresql.org; Sat, 23 May 2026 01:15:41 +0000 Received: by mail-qv1-xf2c.google.com with SMTP id 6a1803df08f44-8b3fe2f19a4so83160456d6.2 for ; Fri, 22 May 2026 18:15:39 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1779498938; cv=none; d=google.com; s=arc-20240605; b=hOzrCtSIEIRIQHA/44TmM8kvYz20dfYxE9HrUlVU5oDcGlu8Kmnq62cvO92hakYx5m 4dp2kn+21nKFiUTKa7nrcGa9kDxV24aEbo2C59yRN+R+X91yQafrooXYJC2pavlWSfSk 4ncZb8GM+ggLEoG/UOR9Y19gVFEskuILfyXq/jYhsTzratmu4NaWqctkMvfH52vIQ+Q6 qrvA/2huoYyzV2Sef4T6W1QyXVGpoNcgpNTtCHstkjyYy+uIkq/khRBfkUL7sMAEY8Zk +5I7Fltq5YuGMPEaWuCD9/PivKHyqtH0hYrUeIWMLMR8EwTSpg8vVSzo0185m7dK1SY/ MGfg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=gvo9Ix4TVw8CzfZ/MvhkrRBTkl3WdNupF/qHY/kcf/U=; fh=eVUSIqo8oW6GlS9+lJ2dMbh393DkmW/G0CKaTSrcg9Y=; b=TUcjb/KqcPtBf14uOwnpTYhnKAajCs9gJQdFuE/ksTc5NhXCG2gz7a8DLQvzfRdO60 evTg/eF7kWAfCS8OwQgQxC50LAOxufafk7SS5r1EoJ+lmX/S6tqkDeu8vCkduvjJ5F6n GKroLbEFs164t9qB0aylCmLvXIRwc0jRwMQVIsp54phIiCjCKWQ+ELiIpMIT8qxrFAmN UvabhHzhAz1RxaRlS8Ch83AFGNCRpSe9won9b4SQgArN6jNO5TKa6lZNqkM243sCkAZz ukomGJCcLgjk9hD3N3glxxedPg+U30pJkiiHa/ifVonSJS00oP1CWAHqsGVrOrNE4F6t ougA==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fittl.com; s=google; t=1779498938; x=1780103738; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=gvo9Ix4TVw8CzfZ/MvhkrRBTkl3WdNupF/qHY/kcf/U=; b=O8xQAmSr/IdEZmTqI81AfUYlvLpO8dnyBgLdxJvOAUPGA4rg2LyvPIN2HKCdpMn8tF tsrR3cBGOCw2j8yTATKg9G7AvPQPSggN3qo2JoJIrjVrXirLUOrLD3YyVJH2Y5azFlFx PDLCKgyD/gQJdu7BR/X8w3k7Rx5MA4TyLWP6s= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1779498938; x=1780103738; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=gvo9Ix4TVw8CzfZ/MvhkrRBTkl3WdNupF/qHY/kcf/U=; b=AqIajIg7L9EHOuBd3XcJMieYASp3JNqI3LVBIgVowu9eVsRVKElUNy3KyzEkZJPj/1 G7igZTJj7MbLFoYowdnnXgFuzMSL2H4mSty+KctmF01s8VtSbCiXMyiC6GlHKzXOcQ5x x/g1fcvcGFdnynFLIiBSwyxSeqyXf+zt+ZKK6nXJUE1vsMqSCeVXwgKFn1ZFDnljuQtL jQm5hvFTlp+UvJintt/0VnRXDsQyllgJYOVn/PR4uebBQW25At5ehN6Zof/U7o7OLkX6 /kFvjUEMBGKXavzv11ibPJ7LsUIs6ufGleF8OInFlRK58iAbJiNJSn0kT7kD8Um311Ok dlTQ== X-Gm-Message-State: AOJu0YyqwqYQEzJGREbRjIY+EP2YJu8W1TlvqagP/Pl4F7iT3unX3TRi es3fS+bEYadtNgLe8hi3VHxdOQBatuzCD8WTZhMrJOkuhP8PC6VTLgV4LgLQGtUZObOVh6mVHje Vpt1yoQ0rZc+jUfPtNau+39epGGOIWhxaIC2Ewplv X-Gm-Gg: Acq92OHI+CZ7LPF/Azv+PZhCvXenP8qQywl1NYQk0lGEmMFt1xienmuM0R0DVBlfcKY LHmbPo3/ICU+0m2g49cAbKRCWxM2HdEqfrK/I+cw4pabj63ZYcfTRHEN+2HNZosJ5VK917vaHQq 50zYXySquYIR/i0dqJtCA7BzWBKv/AtF+eNXgggV6Gurnbm1oiGQjGrA417J2/MPf2cylUqzi8e TKH3TPyxaF4SWFI+A3WZlkuWY21+i+xy6TLNksaLhpL6BkIBrnoz0UpqMTrqufl4pCw2ji1ZGCo vA+JL7nQklJT50duNvGYTtwIWfmzUx3J+OqJLKVXw1gSEOLjzGs6Qa6YGSwH X-Received: by 2002:a05:6214:400a:b0:8ad:7a3e:5c2d with SMTP id 6a1803df08f44-8cc7b65a945mr94705696d6.31.1779498937648; Fri, 22 May 2026 18:15:37 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Lukas Fittl Date: Fri, 22 May 2026 18:15:00 -0700 X-Gm-Features: AVHnY4JBOawywy2naqXtbHRnCoDTy6d6NzRDMimdfThP2zMVpiV4R8jis0nVOrA Message-ID: Subject: Re: Improve pg_stat_statements scalability To: Sami Imseih Cc: pgsql-hackers Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, May 21, 2026 at 9:38=E2=80=AFPM Lukas Fittl wrote= : > > On Mon, May 11, 2026 at 4:54=E2=80=AFPM Sami Imseih = wrote: > > pg_stat_statements has well-known scaling problems under > > high concurrency. This patch series is an initial proposal > > for how to $SUBJECT. > > Agreed. Let's fix this for Postgres 20. > > Thank you for putting together initial patches! For archive's sake and others reading along, we had a productive discussion about this today at PGConf.Dev. I've created a new wiki page combining the prior 2025 discussion, and notes from today: https://wiki.postgresql.org/wiki/Scalability_of_pg_stat_statements Thanks, Lukas --=20 Lukas Fittl