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

Title

Topic

Performance

Created

2022-01-10 22:53:33

Last modified

2022-08-02 18:54:18 (2 months ago)

Latest email

2022-07-23 09:34:54 (2 months, 2 weeks ago)

Status

2022-07: Returned with feedback

2022-03: Moved to next CF

Target version

Authors

Melanie Plageman (melanieplageman)

Reviewers

Become reviewer

Committer

Links

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