Use streaming read I/O in BRIN vacuuming

From: Arseniy Mukhin <arseniy(dot)mukhin(dot)dev(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Use streaming read I/O in BRIN vacuuming
Date: 2025-08-31 16:17:20
Message-ID: CAE7r3ML01aiq9Th_1OSz7U7Aq2pWbhMLoz5T+PXcg8J9ZAPFFA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

B-tree, GiST and SP-GiST take advantage of the read stream API during
vacuuming. BRIN vacuum seems like a perfect candidate for it as well.
During a vacuum it reads the entire relation sequentially, page by
page.

PFA the patch that migrates BRIN vacuum to the read stream API.

Best regards,
Arseniy Mukhin

Attachment Content-Type Size
v1-0001-Use-streaming-read-I-O-in-BRIN-vacuuming.patch text/x-patch 2.1 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Nikolay Shaplov 2025-08-31 17:02:27 [PATCH] trenary reloption type
Previous Message Andrew Jackson 2025-08-31 15:43:22 Re: Adding pg_dump flag for parallel export to pipes