Re: Using read_stream in index vacuum

[Andrey M. Borodin]

> On 25 Oct 2024, at 00:55, Rahila Syed <rahilasye...@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 autovaccum and 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 expected to have better performance. It's 
needed to have decent perfromance when DIRECT_IO will be involved.

Thanks!


Best regards, Andrey Borodin.