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.. -- Michael
signature.asc
Description: PGP signature
