Re: Use read streams in pg_visibility

Hi,

On Mon, 19 Aug 2024 at 09:30, Michael Paquier <michael(at)paquier(dot)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