Re: [Patch] New pg_stat_tablespace view

From: shihao zhong <zhong950419(at)gmail(dot)com>
To: solai v <solai(dot)cdac(at)gmail(dot)com>
Cc: Bernd Reiß <bd_reiss(at)gmx(dot)at>, Ahmed Gouda <ahmed(dot)gouda(at)cybertec(dot)at>, Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>, songjinzhou <tsinghualucky912(at)foxmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, jian he <jian(dot)universality(at)gmail(dot)com>
Subject: Re: [Patch] New pg_stat_tablespace view
Date: 2026-09-21 14:11:09
Message-ID: CAGRkXqRTuz0Eyv9pyrCnPxFbAu__6ei-UmOh2oTB81PqmareGQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message ChenhuiMo 2026-09-21 14:15:34 Re: Skip a redundant singleton GROUP BY node
Previous Message shihao zhong 2026-09-21 14:09:50 Re: [patch] Cache invalidation for I/O Workers