Re: index prefetching

Another quick response, I am impressed

I'm quite confused by the scripts you shared, it seems incomplete. The
> run_regression.py is meant to call purge_cache.sh (which is missing),
> and the run_benchmark tries to call all sorts of missing .sql scripts.
>

That was a confusion I did, I uploaded run_benchmark that was just a
nonsensical AI generated script in my work area and I didn't upload
purge_cache.sh. Notice that you can still run the python script with evict
mode off,pg. The missing script is attached in my previous message.

> A table that is just 24MB and fits into buffers is a bit useless. It
> means that even with random pattern (which is generally about the best
> for prefetching), only about ~1/30 of pages will require I/O. Each page
> has ~32 items, but only the first item from each page will incur an I/O.
>

OK, I will start it with different parameters, for development I needed
something that was not too slow, to be able to catch the bugs.

On what kind of hardware? How much variance is in the results?
>
Is a Mac mini M1. Please check the .PNG it shows the confidence intervals
of the difference of execution time with the parameter ON and OFF, with
different settings.

--
Alexandre