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, 7 months ago)
Latest email 2021-03-16 19:19:25 (3 years, 7 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