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

3508

Title

Topic

Performance

Created

2022-01-10 22:53:33

Last modified

2022-08-02 18:54:18 (2 years, 3 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