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 <[email protected]> Reviewed-by: Fujii Masao <[email protected]> Discussion: https://postgr.es/m/[email protected] Backpatch-through: 16 Branch ------ REL_18_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/4d6ff8a051a13b7c86255ff5d83ff2aa0dce302a Modified Files -------------- src/backend/utils/activity/pgstat_io.c | 14 +++++++------- src/test/regress/expected/stats.out | 3 ++- 2 files changed, 9 insertions(+), 8 deletions(-)
