pgsql: Count write times when extending relation files for shared buffe - Mailing list pgsql-committers

From Michael Paquier
Subject pgsql: Count write times when extending relation files for shared buffe
Date
Msg-id E1qszWP-00176N-1s@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Count write times when extending relation files for shared buffers

Relation files extended multiple blocks at a time have been counting the
number of blocks written, but forgot that to increment the write time in
this case, as write and relation extension are treated as two different
I/O operations in the shared stats: IOOP_EXTEND vs IOOP_WRITE.  In this
case IOOP_EXTEND was forgotten for normal (non-temporary) relations.

Write times are tracked when track_io_timing is enabled, which is not
the case by default.

Author: Nazir Bilal Yavuz
Reviewed-by: Robert Haas, Melanie Plageman
Discussion: https://postgr.es/m/CAN55FZ19Ss279mZuqGbuUNxka0iPbLgYuOQXqAKewrjNrp27VA@mail.gmail.com
Backpatch-through: 16

Branch
------
REL_16_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/2308f18c073333babdcc45139d691a74fae87863

Modified Files
--------------
src/backend/utils/activity/pgstat_io.c | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)


pgsql-committers by date:

Previous
From: Michael Paquier
Date:
Subject: pgsql: Add flush option to pg_logical_emit_message()
Next
From: Peter Eisentraut
Date:
Subject: pgsql: Clean up some pg_dump tests