| From: | Fujii Masao <fujii(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Fix temporary relation I/O statistics in single-user mode |
| Date: | 2026-11-18 07:10:18 |
| Message-ID: | E1xTZo9-00000000CrZ-0RpR@gemulon.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Fix temporary relation I/O statistics in single-user mode
Accessing temporary relations in single-user mode could trigger an
assertion failure in assertion-enabled builds. For example, CREATE
TEMP TABLE AS and CREATE TEMP SEQUENCE failed when recording relation
extension statistics. Without assertions, the statistics were still
collected internally but were not exposed in pg_stat_io.
The problem was that pgstat_tracks_io_object() incorrectly excluded
standalone backends from I/O tracking for temporary relations, even
though they use local buffers just like regular client backends.
Remove this exclusion to prevent the assertion failures and make the
statistics visible in pg_stat_io.
Backpatch to v16, where the incorrect exclusion was introduced in
commit 28e626bde00.
Author: Manuel Reyes Bravo <manuelreyesbravo(at)gmail(dot)com>
Reviewed-by: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Discussion: https://postgr.es/m/179487554022.104798.7544124224648387746@gmail.com
Backpatch-through: 16
Branch
------
REL_19_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/079619ae93398e0ac1c7a24897694b0fb74840df
Modified Files
--------------
src/backend/utils/activity/pgstat_io.c | 14 +++++++-------
src/test/regress/expected/stats.out | 3 ++-
2 files changed, 9 insertions(+), 8 deletions(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fujii Masao | 2026-11-18 07:10:29 | pgsql: Fix temporary relation I/O statistics in single-user mode |
| Previous Message | Fujii Masao | 2026-11-18 07:10:03 | pgsql: Fix temporary relation I/O statistics in single-user mode |