Re: Finalizing read stream users' flag choices

2025-04-08 Thread Andres Freund
hi, On 2025-04-08 12:06:47 -0400, Melanie Plageman wrote: > And a somewhat related point, with buffered IO, READ_STREAM_SEQUENTIAL > disables prefetching to encourage OS readahead. I don't know if any > other users than sequential scan should do this. Worth adding that prefetches are only issued

Re: Finalizing read stream users' flag choices

2025-04-08 Thread Robert Haas
On Tue, Apr 8, 2025 at 12:07 PM Melanie Plageman wrote: > We've said before that maintenance_io_concurrency should govern work > done on behalf of many different sessions. That was said to include at > least vacuum and recovery. I need to change the index vacuum users to > use READ_STREAM_MAINTENA