Use posix fadvise to speed up analyze + improve automatic analyze with "avg read rate" log message

Edit

ID 2799

Title Use posix fadvise to speed up analyze + improve automatic analyze with "avg read rate" log message

Topic Monitoring & Control

Created 2020-10-27 14:34:09

Last modified 2021-03-16 19:38:10 (3 years, 8 months ago)

Latest email 2021-03-16 19:19:25 (3 years, 8 months ago)

Status

2021-03: Committed

2021-01: Moved to next CF

2020-11: Moved to next CF

Target version 14

Authors Stephen Frost (sfrost), Jakub Wartak (jakub.wartak.tomtom)

Reviewers Heikki Linnakangas (heikki), Tomas Vondra (fuzzycz)Become reviewer

Committer Stephen Frost (sfrost)

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/2799
git checkout commitfest/cf/2799

Emails

automatic analyze: readahead - add "IO read time" log message: First at 2020-10-26 12:21:01 by Jakub Wartak <Jakub.Wartak at tomtom.com>
Latest at 2020-10-26 15:44:15 by Stephen Frost <sfrost at snowman.net>
Latest attachment (0001-do_analyze_rel_ioreadtimings_patch.c) at 2020-10-26 12:21:01 from Jakub Wartak <Jakub.Wartak at tomtom.com>
Attachment (0001-do_analyze_rel_ioreadtimings_patch.c) at 2020-10-26 12:21:01 from Jakub Wartak <Jakub.Wartak at tomtom.com> (Patch: Yes)
Re: automatic analyze: readahead - add "IO read time" log message: First at 2020-10-27 15:06:05 by Jakub Wartak <Jakub.Wartak at tomtom.com>
Latest at 2020-10-27 15:35:26 by Stephen Frost <sfrost at snowman.net>
Latest attachment (0002-do_analyze_rel_ioreadtimings_patch.c) at 2020-10-27 15:06:05 from Jakub Wartak <Jakub.Wartak at tomtom.com>
Attachment (0002-do_analyze_rel_ioreadtimings_patch.c) at 2020-10-27 15:06:05 from Jakub Wartak <Jakub.Wartak at tomtom.com> (Patch: Yes)
Re: automatic analyze: readahead - add "IO read time" log message: First at 2020-11-04 09:07:59 by Jakub Wartak <Jakub.Wartak at tomtom.com>
Latest at 2021-03-16 19:19:25 by Stephen Frost <sfrost at snowman.net>
Latest attachment (analyze_prefetch_v9.patch) at 2021-03-12 00:11:56 from Stephen Frost <sfrost at snowman.net>
    Attachment (analyze_prefetch_v9.patch) at 2021-03-12 00:11:56 from Stephen Frost <sfrost at snowman.net> (Patch: Yes)
    Attachment (analyze_prefetch_v8.patch) at 2021-03-08 19:42:53 from Stephen Frost <sfrost at snowman.net> (Patch: Yes)
    Attachment (analyze_prefetch_v7.patch) at 2021-03-08 03:26:18 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (analyze_prefetch_v6.patch) at 2021-02-10 22:10:08 from Stephen Frost <sfrost at snowman.net> (Patch: Yes)
    Attachment (analyze_prefetch_v5.patch) at 2021-02-05 21:22:34 from Stephen Frost <sfrost at snowman.net> (Patch: Yes)
    Attachment (analyze_prefetch_v4.patch) at 2021-01-13 21:17:24 from Stephen Frost <sfrost at snowman.net> (Patch: Yes)
    Attachment (analyze_prefetch_v3.patch) at 2020-11-09 18:06:44 from Stephen Frost <sfrost at snowman.net> (Patch: Yes)
    Attachment (analyze_prefetch_v2.patch) at 2020-11-04 16:02:14 from Stephen Frost <sfrost at snowman.net> (Patch: Yes)

History

When	Who	What
2021-03-16 19:38:10	Stephen Frost (sfrost)	Changed reviewers to Heikki Linnakangas (heikki), Tomas Vondra (fuzzycz)
2021-03-16 19:37:31	Stephen Frost (sfrost)	Closed in commitfest 2021-03 with status: Committed
2021-03-16 19:37:11	Stephen Frost (sfrost)	Added sfrost as committer
2021-03-12 01:22:15	Justin Pryzby (justinpryzby)	New status: Ready for Committer
2021-02-01 12:27:07	Masahiko Sawada (masahikosawada)	Closed in commitfest 2021-01 with status: Moved to next CF
2021-01-26 10:25:50	Heikki Linnakangas (heikki)	Added heikki as reviewer
2020-12-07 07:51:29	Jakub Wartak (jakub.wartak.tomtom)	Changed authors to Stephen Frost (sfrost), Jakub Wartak (jakub.wartak.tomtom)
2020-12-05 16:35:36	Stephen Frost (sfrost)	Changed name to Use posix fadvise to speed up analyze + improve automatic analyze with "avg read rate" log message
2020-12-01 08:56:19	Georgios Kokolatos (gkokolatos)	Closed in commitfest 2020-11 with status: Moved to next CF
2020-11-09 09:36:02	Jakub Wartak (jakub.wartak.tomtom)	Attached mail thread VI1PR0701MB69603A433348EDCF783C6ECBF6EF0@VI1PR0701MB6960.eurprd07.prod.outlook.com
2020-10-27 15:17:05	Jakub Wartak (jakub.wartak.tomtom)	Attached mail thread VI1PR0701MB69603772FDF522FE0B4BFD80F6160@VI1PR0701MB6960.eurprd07.prod.outlook.com
2020-10-27 15:16:37	Jakub Wartak (jakub.wartak.tomtom)	Changed authors to Jakub Wartak (jakub.wartak.tomtom)
2020-10-27 14:34:28	Jakub Wartak (jakub.wartak.tomtom)	Changed targetversion to 14
2020-10-27 14:34:09	Jakub Wartak (jakub.wartak.tomtom)	Attached mail thread VI1PR0701MB6960361E83FE46E71FBC8811F6190@VI1PR0701MB6960.eurprd07.prod.outlook.com
2020-10-27 14:34:09	Jakub Wartak (jakub.wartak.tomtom)	Created patch record

Edit