From: | Thomas Munro <tmunro(at)postgresql(dot)org> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: Don't count zero-filled buffers as 'read' in EXPLAIN. |
Date: | 2018-11-27 23:01:29 |
Message-ID: | E1gRmMD-0008TM-89@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Don't count zero-filled buffers as 'read' in EXPLAIN.
If you extend a relation, it should count as a block written, not
read (we write a zero-filled block). If you ask for a zero-filled
buffer, it shouldn't be counted as read or written.
Later we might consider counting zero-filled buffers with a separate
counter, if they become more common due to future work.
Author: Thomas Munro
Reviewed-by: Haribabu Kommi, Kyotaro Horiguchi, David Rowley
Discussion: https://postgr.es/m/CAEepm%3D3JytB3KPpvSwXzkY%2Bdwc5zC8P8Lk7Nedkoci81_0E9rA%40mail.gmail.com
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/d67dae036bd71afd2be7a2fafd7bc1ef38bfcdd1
Modified Files
--------------
src/backend/storage/buffer/bufmgr.c | 10 ++++++++--
1 file changed, 8 insertions(+), 2 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Tomas Vondra | 2018-11-28 00:00:54 | pgsql: Use wildcard to match parens after CREATE STATISTICS |
Previous Message | Michael Paquier | 2018-11-27 21:36:25 | Re: pgsql: Add TAP tests for pg_verify_checksums |