Re: Avoiding smgrimmedsync() during nbtree index builds

From:	Justin Pryzby <pryzby(at)telsasoft(dot)com>
To:	Melanie Plageman <melanieplageman(at)gmail(dot)com>
Cc:	Andres Freund <andres(at)anarazel(dot)de>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, pgsql-hackers(at)postgresql(dot)org, Peter Geoghegan <pg(at)bowt(dot)ie>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
Subject:	Re: Avoiding smgrimmedsync() during nbtree index builds
Date:	2022-03-03 01:09:49
Message-ID:	20220303010949.GC27651@telsasoft.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2021-01-21 20:36:56 from Andres Freund <andres(at)anarazel(dot)de> 📎  2021-01-21 21:54:04 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi>   2021-01-21 22:51:23 from Andres Freund <andres(at)anarazel(dot)de>    2021-05-03 21:24:50 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎     2021-09-29 18:35:47 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎      2022-01-13 17:18:39 from Robert Haas <robertmhaas(at)gmail(dot)com>     2021-11-19 20:11:57 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎      2021-11-23 20:51:51 from Melanie Plageman <melanieplageman(at)gmail(dot)com>      2021-12-09 19:33:51 from Andres Freund <andres(at)anarazel(dot)de>       2022-01-10 22:50:40 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎        2022-01-11 17:10:54 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎         2022-01-13 15:52:55 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎          2022-01-16 20:25:59 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎           2022-01-17 17:22:07 from Justin Pryzby <pryzby(at)telsasoft(dot)com>         2022-01-23 21:55:41 from Andres Freund <andres(at)anarazel(dot)de>          2022-02-09 18:49:30 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎           2022-02-13 14:33:13 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>           2022-03-03 01:09:49 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎            2022-03-04 22:03:09 from Melanie Plageman <melanieplageman(at)gmail(dot)com> 📎             2022-03-10 18:32:51 from Andres Freund <andres(at)anarazel(dot)de>              2022-03-30 18:54:23 from Greg Stark <stark(at)mit(dot)edu>               2022-08-02 18:54:21 from Jacob Champion <jchampion(at)timescale(dot)com>             2022-07-23 09:34:54 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
0001-Add-unbuffered-IO-API.patch	text/x-diff	31.8 KB
0002-Avoid-immediate-fsync-for-unbuffered-IO.patch	text/x-diff	12.2 KB
0003-BTree-index-use-unbuffered-IO-optimization.patch	text/x-diff	2.1 KB
0004-Use-shared-buffers-when-possible-for-index-build.patch	text/x-diff	19.1 KB

In response to

• Re: Avoiding smgrimmedsync() during nbtree index builds at 2022-02-09 18:49:30 from Melanie Plageman

Responses

• Re: Avoiding smgrimmedsync() during nbtree index builds at 2022-03-04 22:03:09 from Melanie Plageman

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Michael Paquier	2022-03-03 01:10:36	Re: pg_stop_backup() v2 incorrectly marked as proretset
Previous Message	Melanie Plageman	2022-03-03 01:07:14	Why do spgbuildempty(), btbuildempty(), and blbuildempty() use smgrwrite()?