Hi, On Mon, 19 Aug 2024 at 09:30, Michael Paquier <mich...@paquier.xyz> wrote: > > On Tue, Aug 13, 2024 at 03:22:27PM +0300, Nazir Bilal Yavuz wrote: > > Hi, > > > > I am working on using the read stream in pg_visibility. There are two > > places to use it: > > > > 1- collect_visibility_data() > > > > This one is straightforward. I created a read stream object if > > 'include_pd' is true because read I/O is done when 'include_pd' is > > true. There is ~4% timing improvement with this change. I started the > > server with the default settings and created a 6 GB table. Then run > > 100 times pg_visibility() by clearing the OS cache between each run. > > ---------- > > Mind sharing a script for reproducibility? Except for the drop_caches > part, of course..
Sure, the script is attached. -- Regards, Nazir Bilal Yavuz Microsoft
setup.sh
Description: application/shellscript
