> On 25 Oct 2024, at 00:55, Rahila Syed <rahilasyed90@gmail.com> wrote:
>
> While writing this email, I realized I evicted buffers for the table
> and not the index. I will perform the test again. However,
> I would like to know your opinion on whether this looks like
> a valid test.
Well, yes, kind of, you need drop caches from index. And, perhaps, you can have more indexes. You also can disable
autovaccumand just restart postgres instead of iterating through buffer caches.
I've asked Thomas about performance implications and he told me that converting stuff to streamlined API is not
expectedto have better performance. It's needed to have decent perfromance when DIRECT_IO will be involved.
Thanks!
Best regards, Andrey Borodin.