Re: Use streaming read I/O in BRIN vacuuming - Mailing list pgsql-hackers

From Andrey Borodin
Subject Re: Use streaming read I/O in BRIN vacuuming
Date
Msg-id 40C3C039-C781-4295-B4C3-F9F4F3E401EC@yandex-team.ru
Whole thread Raw
In response to Use streaming read I/O in BRIN vacuuming  (Arseniy Mukhin <arseniy.mukhin.dev@gmail.com>)
Responses Re: Use streaming read I/O in BRIN vacuuming
List pgsql-hackers
Hi!

> On 31 Aug 2025, at 21:17, Arseniy Mukhin <arseniy.mukhin.dev@gmail.com> wrote:
>
> PFA the patch that migrates BRIN vacuum to the read stream API.

The patch is nice and straightforward. Looks good to me.

Some notes that do not seem to me problem of this patch:
1. This comment is copied 7 times already across codebase.
"It is safe to use batchmode as block_range_read_stream_cb"
Maybe we can refactor comments and function names...
2. Somehow brin_vacuum_scan() avoid dance of getting RelationGetNumberOfBlocks() many times to be entirely sure
everythingis scanned. Unlike other index vacuums, see btvacuumscan() for example. 


Best regards, Andrey Borodin.


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Adding REPACK [concurrently]
Next
From: Bruce Momjian
Date:
Subject: Re: PG 18 relnotes and RC1