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 1wQxfz-0020oq-1a for pgsql-hackers@arkaria.postgresql.org; Sun, 24 May 2026 01:30:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wQxew-00GJuI-1c for pgsql-hackers@arkaria.postgresql.org; Sun, 24 May 2026 01:29:43 +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 1wQxew-00GJu7-0K for pgsql-hackers@lists.postgresql.org; Sun, 24 May 2026 01:29:43 +0000 Received: from mail-ed1-x530.google.com ([2a00:1450:4864:20::530]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wQxet-000000017p0-3yfV for pgsql-hackers@postgresql.org; Sun, 24 May 2026 01:29:42 +0000 Received: by mail-ed1-x530.google.com with SMTP id 4fb4d7f45d1cf-68896f2e7d0so1340403a12.0 for ; Sat, 23 May 2026 18:29:39 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1779586177; cv=none; d=google.com; s=arc-20240605; b=ZghJfLgXuBd2RDL+fvG9Be/yeboXzVyySAHBgaeDXsxLZcKXG6OWR9fr62g2eYC/gu 6R/znYkWgub32BKWOLbCPSb5UIV/IJFu27M4DAyZSL3Dvi/ahaI8ttnsFQ/x3d40UCTW 8UjjdAhP17vfD1yxT/Lm9Fo6pMV1kTrzOP1uMkurare/VqoblW3C2yGtb576HWnd48ED 2ct3CKKofWy3YUKOE8Gr/gawhslrzxEmu8wBxt37qwlPxWCOoxEju49IVMRoRTe8Q5yR 2c8m/o920kmn5hbuhCrMe3/r+6ZkaJQBPhDCxPueBY4MHzgXk5nP/mrYq3mwN0Bx0rEn v23A== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=LoANbUPiBUjlabKPawS9LxWKsb8qIJkgzl1i4PdEkrw=; fh=uqaFqNrYI8BanjCkBA3wRFUOs+utYRup+YPmG3CyJ5k=; b=Lw/+ORk7Mrwgjg+FnkCuR0M6a7W2V5RgDOGfhnijqZhh5LYCc9zN7zbmfzobW3NPEf LUCCQWcnrX8SlFD0us1PaO9Tpo+ZdpN8ziAnfJ2iBp+kfYyrUczmbCS4e9U/saVAum58 2HProaYb02q7rIGZublN3LO6DRVXssK+RF2rn+SgJ7YwdAfvJ9d/C3sDA5xE4JtsGBLx KjMACh/9a1FkiDyclW4OzUzYKk81qivnAx2ezzEzJIi35MA5TPCQXDd22bM9FdNfgcby VAL75UKcxHqjKEgxIt0JTqa8n4/bNmSldcwxQ9jlteazOtS+GyPOSLJrt3K+FCJRrRyY kQLw==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1779586177; x=1780190977; 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=LoANbUPiBUjlabKPawS9LxWKsb8qIJkgzl1i4PdEkrw=; b=LUj4d7AMjrvBnCoxLFPhKOXo/WlDYUA8sJLV3WWrvwMNYuqghZBwSe07NZ3f8zX266 dYrDrtGjp12g8wchQbPHs14Wzo9EBf65gDYrH5cAteY1KQ6S2MKpBIpAjjKPEjGg9tLb iEwQqIEO0UQkzKbvgvZHMOHb+bKhCoQKJFuNpVX14IrOTnrD/AZ8ckmIHrvZC8YWMrHZ 5ZtFgIY9SfqM3dLC3JnqWrJUOOqTmvHii/VqspbnI5pagPjyhZS+ChwkiGQwnOl241v5 ahu27ders1OdZ47giDrIMcRnNOXSVgf5KzrhR9bXKVhJFLq16bHVd8VXqhqs9vsu6qCT mW1Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1779586177; x=1780190977; h=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=LoANbUPiBUjlabKPawS9LxWKsb8qIJkgzl1i4PdEkrw=; b=YKxRpZ0crcWKbmWsH1RURq73/SSjrP50cO60QyAqtH4MeZFYaY1Qiwc9nBYr4Isdpy yqPrzSX32n1M51yO7cn4K8Dt1UQxbpoTXpk5ntUuQ4iZG8N078t9e3mSHTQemxGDPp1M jv7hOqPWGGm3BSV/iDfMC1htIRQIXMUBu+D1rleRfHUFxXUyG6yx/oA6Bb4s8uxQpoZp bdWrGmXMvlbalTK+gDzTGVcNBrzSfq993fRC04FUuYtCLfYoDDI537sDvjzIJGzwbPVQ 8QKzve9ZNhyard6V/GcFVrPeTUENh4L9cre3UWZM9zgkdbpfkJHnAAzqrjXSk61KJO9I zbew== X-Gm-Message-State: AOJu0YxYM17HuPa1WPN589kqLN2jlsmeU/uUpDVI7FJp9V3nUNnklCb+ ZMzH5q1HbnZn4MY58VSyAQrl9GhWJ+Kq9pGRXBaKh9o3waWJLyrL2rBaQyDrKYts9nrWV++bxvL lQ0s+urbbdHiSS6X2Zie2JyAKyP/FGJI= X-Gm-Gg: Acq92OE1txk6j8hFkU0j3rt+FXBwJU5i0e00G5RBmpr+iYZe9CxhEvT77EE4y1dGmjJ R2/dp/xjWDESR0eKPLM9W1VaS5FfJRX+cs7A2tBFEImTROiOblWHuht6Y94Oy/gzaHdx3HucjcS XgfAWphHbVnZIdKnnRbKlFC2rojh6gdVWvs3REzH+O+0Jt+gVLJ95i0zJRtlUP7BTE2Na3lIuJz qiaRU9t/nmn9gEzMQAZp3HS1FG/MOvp9tl9muyO4QUjwUhSuX/uDCpja8Wa301HLB7IN8Jck+4k sT+9DDBemf43/kJP9dk/fGhSbhCb/AZImulT21zASIDZp1K2 X-Received: by 2002:a05:6402:34cf:b0:672:88a7:3885 with SMTP id 4fb4d7f45d1cf-6889cc31c78mr1147215a12.18.1779586176971; Sat, 23 May 2026 18:29:36 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Sami Imseih Date: Sat, 23 May 2026 20:29:26 -0500 X-Gm-Features: AVHnY4Kv7kHM4C8FXyCgHPI2LEcNbDVpFphY-paMhrtqXMJYXSOSvIE3EeAmPVc Message-ID: Subject: Re: Improve pg_stat_statements scalability To: Lukas Fittl Cc: pgsql-hackers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > > > 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 Thank you, Lukas! -- Sami