Re: Improve pg_stat_statements scalability

From: Sami Imseih <samimseih(at)gmail(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Improve pg_stat_statements scalability
Date: 2026-05-17 17:37:23
Message-ID: CAA5RZ0u-Y4HHTdBpJMn5if6DnOnj-Bn9MmPKJ=28Y5dkpHhCoA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I had to fix an issue with the serialization callback that was causing
CI failures.

I also made re-organized the patches a bit:

v1-0001: This will not be part of the main patchset, but will be be a dependency
for the remaining patches. This is, as mentioned above, an in-transaction flush
required [1]

v1-0002: This now only moves the pg_stat_statements hash to a custom
pgstat kind

v1-0003: This moves the query text file to a DSA + file storage.

v1-0004: Adds new columns to pg_stat_statements_info

[1] https://commitfest.postgresql.org/patch/6781/

--
Sami Imseih
Amazon Web Services (AWS)

Attachment Content-Type Size
v1-0003-pg_stat_statements-add-DSA-based-query-text-stora.patch application/octet-stream 18.4 KB
v1-0002-pg_stat_statements-modernize-entry-storage-with-p.patch application/octet-stream 76.9 KB
v1-0004-pg_stat_statements-extend-pg_stat_statements_info.patch application/octet-stream 5.0 KB
v1-0001-pgstat-Introduce-pg_stat_report_anytime-for-mid-t.patch application/octet-stream 28.5 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jelte Fennema-Nio 2026-05-17 20:15:55 Re: meson: Make test output much more useful on failure (both in CI and locally)
Previous Message Mohamed ALi 2026-05-17 16:45:40 Re: [PATCH] Add NESTED_STATEMENTS option to EXPLAIN