| From: | Melanie Plageman <melanieplageman(at)gmail(dot)com> |
|---|---|
| To: | Thomas Munro <thomas(dot)munro(at)gmail(dot)com> |
| Cc: | Tomas Vondra <tomas(at)vondra(dot)me>, Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Andres Freund <andres(at)anarazel(dot)de>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: BitmapHeapScan streaming read user and prelim refactoring |
| Date: | 2025-03-10 23:45:38 |
| Message-ID: | CAAKRu_Z4ekRbfTacYYVrvu9xRqS6G4DMbZSbN_1usaVtj+bv2w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Mar 10, 2025 at 3:06 PM Melanie Plageman
<melanieplageman(at)gmail(dot)com> wrote:
>
> The takeaway is that I think 16 is a good default effectio_io_concurrency value.
Attached v35 0003-0005 is the same as v34 but is on top of two new
commits: 0001 increases the default effective_io_concurrency to 16 and
0002 adds a READ_STREAM_RANDOM flag which disables sequential
detection and is used by bitmap heap scan.
- Melanie
| Attachment | Content-Type | Size |
|---|---|---|
| v35-0002-Add-READ_STREAM_RANDOM-flag.patch | text/x-patch | 4.6 KB |
| v35-0001-Increase-default-effective_io_concurrency-to-16.patch | text/x-patch | 5.8 KB |
| v35-0004-BitmapHeapScan-uses-the-read-stream-API.patch | text/x-patch | 28.9 KB |
| v35-0003-Separate-TBM-Shared-Private-Iterator-and-TBMIter.patch | text/x-patch | 19.4 KB |
| v35-0005-Remove-table-AM-callback-scan_bitmap_next_block.patch | text/x-patch | 22.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Davis | 2025-03-10 23:53:50 | Re: Statistics Import and Export: difference in statistics dumped |
| Previous Message | Masahiko Sawada | 2025-03-10 23:29:27 | Re: Parallel heap vacuum |