Avoid smgrimmedsync() during index build and add unbuffered IO API

Edit
ID 3508
Title Avoid smgrimmedsync() during index build and add unbuffered IO API
Topic Performance
Created 2022-01-10 22:53:33
Last modified 2022-08-02 18:54:18 (2 years, 2 months ago)
Latest email 2022-07-23 09:34:54 (2 years, 3 months ago)
Status
2022-07: Returned with feedback
2022-03: Moved to next CF
Target version
Authors Melanie Plageman (melanieplageman)
Reviewers Become reviewer
Committer
Links CFbot results (CirrusCI) CFbot GitHub
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run:
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/3508
git checkout commitfest/cf/3508
Emails
Avoiding smgrimmedsync() during nbtree index builds
First at 2021-01-21 20:36:56 by Andres Freund <andres at anarazel.de>
Latest at 2022-07-23 09:34:54 by Heikki Linnakangas <hlinnaka at iki.fi>
Latest attachment (v6-0003-BTree-index-use-unbuffered-IO-optimization.patch) at 2022-03-04 22:03:09 from Melanie Plageman <melanieplageman at gmail.com>
    Attachment (v6-0003-BTree-index-use-unbuffered-IO-optimization.patch) at 2022-03-04 22:03:09 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (0001-Add-unbuffered-IO-API.patch) at 2022-03-03 01:09:49 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v5-0001-Add-unbuffered-IO-API.patch) at 2022-02-09 18:49:30 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (crashlog-postgres.exe_0fa8_2022-01-16_02-54-35-291.txt) at 2022-01-16 20:25:59 from Justin Pryzby <pryzby at telsasoft.com> (Patch: No)
    Attachment (0003-cirrus-run-initdb-with-data-checksums-for-windows.txt) at 2022-01-13 15:52:55 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v4-0002-Use-shared-buffers-when-possible-for-index-build.patch) at 2022-01-11 17:10:54 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Add-unbuffered-IO-and-avoid-immed-fsync.patch) at 2022-01-10 22:50:40 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Index-build-avoids-immed-fsync.patch) at 2021-11-19 20:11:57 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Add-unbuffered-IO-and-avoid-immed-fsync.patch) at 2021-09-29 18:35:47 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Index-build-avoids-immed-fsync.patch) at 2021-05-03 21:24:50 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (createlots.sql) at 2021-01-21 20:36:56 from Andres Freund <andres at anarazel.de> (Patch: No)
History
When Who What
2022-08-02 18:54:18 Jacob Champion (jchampion) Closed in commitfest 2022-07 with status: Returned with feedback
2022-03-30 18:49:22 Greg Stark (stark) Closed in commitfest 2022-03 with status: Moved to next CF
2022-03-30 18:49:05 Greg Stark (stark) New status: Waiting on Author
2022-01-10 22:53:51 Melanie Plageman (melanieplageman) Changed authors to Melanie Plageman (melanieplageman)
2022-01-10 22:53:34 Melanie Plageman (melanieplageman) Attached mail thread 20210121203656.tc7kqildbqnyihog@alap3.anarazel.de
2022-01-10 22:53:33 Melanie Plageman (melanieplageman) Created patch record
Edit