Re: [Patch] New pg_stat_tablespace view - Mailing list pgsql-hackers

From shihao zhong
Subject Re: [Patch] New pg_stat_tablespace view
Date
Msg-id CAGRkXqRTuz0Eyv9pyrCnPxFbAu__6ei-UmOh2oTB81PqmareGQ@mail.gmail.com
Whole thread
In response to Re: [Patch] New pg_stat_tablespace view  (solai v <solai.cdac@gmail.com>)
List pgsql-hackers
Hi Solai,

Thanks for testing.

> One concern is that this targeted workload did not demonstrate nonzero
> physical-read counters or read timing.

That is expected. The pages you just wrote are still in shared buffers, so
later scans count as blks_hit and there is nothing to read from disk. Restart
the server and scan the table again, and blks_read and blk_read_time should
go up.

The regression test covers this path.

Thanks,
Shihao

pgsql-hackers by date:

Previous
From: shihao zhong
Date:
Subject: Re: [patch] Cache invalidation for I/O Workers
Next
From: "ChenhuiMo"
Date:
Subject: Re: Skip a redundant singleton GROUP BY node