Request a Demo
Home   >   mailing lists

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

From Arseniy Mukhin
Subject Use streaming read I/O in BRIN vacuuming
Date
Msg-id CAE7r3ML01aiq9Th_1OSz7U7Aq2pWbhMLoz5T+PXcg8J9ZAPFFA@mail.gmail.com
Whole thread Raw
Responses Re: Use streaming read I/O in BRIN vacuuming
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Andrew Jackson
Date:
Subject: Re: Adding pg_dump flag for parallel export to pipes
Next
From: Nikolay Shaplov
Date:
Subject: [PATCH] trenary reloption type