pgsql: Don't count zero-filled buffers as 'read' in EXPLAIN.

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(-)

Browse pgsql-committers by date

  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