Re: Finalizing read stream users' flag choices

On Tue, Apr 8, 2025 at 12:07 PM Melanie Plageman
<melanieplageman(at)gmail(dot)com> 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_MAINTENANCE. But I wonder about the other users like
> amcheck and autoprewarm.

autoprewarm, and possibly regular prewarm, seem like maintenance to
me. amcheck does not.

Otherwise, the choices you've made about what is maintenance seem
reasonable to me, based on the list you included further down in the
email.

I don't know enough to opine on the questions about full vs. default,
or sequential scans.

--
Robert Haas
EDB: http://www.enterprisedb.com