BRIN multi-minmax and bloom indexes

Edit
ID 2523
Title BRIN multi-minmax and bloom indexes
Topic Performance
Created 2020-04-02 02:31:24
Last modified 2021-03-26 13:09:17 (3 years, 6 months ago)
Latest email 2021-03-27 20:42:05 (3 years, 6 months ago)
Status
2021-03: Committed
2021-01: Moved to next CF
2020-11: Moved to next CF
2020-09: Moved to next CF
2020-07: Moved to next CF
Target version
Authors Tomas Vondra (fuzzycz)
Reviewers John Naylor (john.naylor)Become reviewer
Committer Tomas Vondra (fuzzycz)
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/2523
git checkout commitfest/cf/2523
Emails
WIP: BRIN bloom indexes
First at 2017-10-19 20:15:32 by Tomas Vondra <tomas.vondra at 2ndquadrant.com>
Latest at 2017-10-28 01:16:51 by Tomas Vondra <tomas.vondra at 2ndquadrant.com>
Latest attachment (brin-bloom-v1.patch) at 2017-10-19 20:15:32 from Tomas Vondra <tomas.vondra at 2ndquadrant.com>
    Attachment (brin-bloom-v1.patch) at 2017-10-19 20:15:32 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
WIP: BRIN multi-range indexes
First at 2017-10-25 16:22:54 by Tomas Vondra <tomas.vondra at 2ndquadrant.com>
Latest at 2021-03-27 20:42:05 by Tomas Vondra <tomas.vondra at enterprisedb.com>
Latest attachment (brin_pg_amproc_cleanup.patchx) at 2021-03-23 17:56:30 from Tomas Vondra <tomas.vondra at enterprisedb.com>
    Attachment (brin_pg_amproc_cleanup.patchx) at 2021-03-23 17:56:30 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-fixup-opclass-storage-type-20210323.patch) at 2021-03-23 01:13:10 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Move-bsearch_arg-to-src-port-20210322.patch) at 2021-03-22 05:27:32 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (jcn-costing-test.sql) at 2021-03-17 20:55:02 from John Naylor <john.naylor at enterprisedb.com> (Patch: No)
    Attachment (0001-introduce-bsearch_arg-20210311.patch) at 2021-03-11 16:26:06 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-introduce-bsearch_arg-20210308b.patch) at 2021-03-08 12:50:28 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-introduce-bsearch_arg-20210308.patch) at 2021-03-08 00:53:03 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-introduce-bsearch_arg-20210305.patch) at 2021-03-05 00:37:54 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Pass-all-scan-keys-to-BRIN-consistent-funct-20210303.patch) at 2021-03-02 23:32:04 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Pass-all-scan-keys-to-BRIN-consistent-funct-20210215.patch) at 2021-02-15 14:37:01 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0009-Ignore-correlation-for-new-BRIN-opclasses-20210211.patch) at 2021-02-11 14:51:31 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0009-Ignore-correlation-for-new-BRIN-opclasses-20210203.patch) at 2021-02-03 23:54:25 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Pass-all-scan-keys-to-BRIN-consistent-funct-20210122.patch) at 2021-01-22 01:05:55 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Pass-all-scan-keys-to-BRIN-consistent-fun-20210114-2.patch) at 2021-01-14 14:32:57 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Pass-all-scan-keys-to-BRIN-consistent-funct-20210114.patch) at 2021-01-13 23:11:40 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Pass-all-scan-keys-to-BRIN-consistent-funct-20210112.patch) at 2021-01-13 01:09:19 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0008-Ignore-correlation-for-new-BRIN-opclasses-20201220.patch) at 2020-12-20 00:16:05 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Pass-all-scan-keys-to-BRIN-consistent-funct-20201108.patch) at 2020-11-08 18:21:51 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (i5.ods) at 2020-11-07 20:38:28 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: No)
    Attachment (0001-Pass-all-scan-keys-to-BRIN-consistent-funct-20201103.patch) at 2020-11-02 23:25:45 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (one-hash-bloom-filter-20200917b.txt) at 2020-09-24 21:18:03 from John Naylor <john.naylor at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-Pass-all-scan-keys-to-BRIN-consistent-func-20200917b.patch) at 2020-09-17 19:19:18 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-Pass-all-scan-keys-to-BRIN-consistent-funct-20200917.patch) at 2020-09-17 16:34:26 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (0004-BRIN-bloom-indexes-20200913.patch) at 2020-09-13 16:40:43 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-Pass-all-scan-keys-to-BRIN-consistent-funct-20200912.patch) at 2020-09-12 16:13:03 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-Pass-all-keys-to-BRIN-consistent-function--20200911b.patch) at 2020-09-11 18:05:10 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-Pass-all-keys-to-BRIN-consistent-function-a-20200911.patch) at 2020-09-11 10:14:41 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-Pass-all-keys-to-BRIN-consistent-function-a-20200906.patch) at 2020-09-05 23:20:42 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-Pass-all-keys-to-BRIN-consistent-function-a-20200807.patch) at 2020-08-07 16:27:01 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-Pass-all-keys-to-BRIN-consistent-function-a-20200703.patch) at 2020-07-03 00:57:37 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-Pass-all-keys-to-BRIN-consistent-function-a-20200513.patch) at 2020-05-13 01:01:38 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-Pass-all-keys-to-BRIN-consistent-function-a-20200402.patch) at 2020-04-02 02:29:04 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-Introduce-opclass-parameters.patch.gz) at 2019-09-14 17:30:49 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (0001-Add-opclass-parameters-20190611.patch) at 2019-06-11 17:30:52 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-Pass-all-keys-to-BRIN-consistent-function-at-once-20190312.patch.gz) at 2019-03-12 10:33:55 from Nikita Glukhov <n.gluhov at postgrespro.ru> (Patch: No)
    Attachment (0001-Pass-all-keys-to-BRIN-consistent-function-a-20190223.patch.gz) at 2019-02-23 22:23:22 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (0001-Pass-all-keys-to-BRIN-consistent-function-a-20180625.patch.gz) at 2018-06-25 00:14:20 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (0001-Pass-all-keys-to-BRIN-consistent-function-at-once.patch.gz) at 2018-06-24 02:01:47 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (0001-Pass-all-keys-to-BRIN-consistent-function-a-20180403.patch.gz) at 2018-04-03 19:50:55 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (0001-Pass-all-keys-to-BRIN-consistent-function-a-20180320.patch.gz) at 2018-03-21 00:07:22 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (0001-Pass-all-keys-to-BRIN-consistent-function-at-once.patch.gz) at 2018-03-04 00:14:06 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (0001-Pass-all-keys-to-BRIN-consistent-function-at-once.patch.gz) at 2018-02-25 00:30:47 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (0001-Pass-all-keys-to-BRIN-consistent-function-at-once.patch) at 2018-02-05 18:57:06 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-Pass-all-keys-to-BRIN-consistent-function-at-once.patch.gz) at 2018-01-07 16:13:55 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (0001-Pass-all-keys-to-BRIN-consistent-function-at-once.patch.gz) at 2017-12-20 01:16:54 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (regression.diffs) at 2017-12-19 19:38:08 from Mark Dilger <hornschnorter at gmail.com> (Patch: Yes)
    Attachment (0001-Pass-all-keys-to-BRIN-consistent-function-at-once.patch.gz) at 2017-11-18 20:45:39 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (0001-Pass-all-keys-to-BRIN-consistent-function-at-once.patch.gz) at 2017-10-30 20:51:26 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (0001-brin-bloom-v1.patch) at 2017-10-25 16:51:44 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (brin-multi-range-v1.patch) at 2017-10-25 16:22:54 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
History
When Who What
2021-03-26 13:09:17 Tomas Vondra (fuzzycz) Closed in commitfest 2021-03 with status: Committed
2021-03-26 13:09:17 Tomas Vondra (fuzzycz) Changed committer to fuzzycz
2021-03-23 01:17:30 Tomas Vondra (fuzzycz) Attached mail thread 5d78b774-7e9c-c94e-12cf-fef51cc89b1a@2ndquadrant.com
2021-03-17 19:00:00 John Naylor (john.naylor) New status: Ready for Committer
2021-02-01 12:33:37 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-01 with status: Moved to next CF
2020-12-01 11:00:50 Anastasia Lubennikova (lubennikovaav) Closed in commitfest 2020-11 with status: Moved to next CF
2020-11-02 18:05:27 Anastasia Lubennikova (lubennikovaav) Posted comment with messageid <160434032777.4948.12542847889193566385.pgcf@coridan.postgresql.org>
2020-10-01 04:26:01 Michael Paquier (michael-kun) Closed in commitfest 2020-09 with status: Moved to next CF
2020-09-17 19:32:32 John Naylor (john.naylor) Added john.naylor as reviewer
2020-09-08 14:13:55 John Naylor (john.naylor) New status: Needs review
2020-09-05 01:46:43 Michael Paquier (michael-kun) New status: Waiting on Author
2020-08-02 21:05:15 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2020-07 with status: Moved to next CF
2020-04-02 02:31:35 Tomas Vondra (fuzzycz) Changed authors to Tomas Vondra (fuzzycz)
2020-04-02 02:31:24 Tomas Vondra (fuzzycz) Attached mail thread c1138ead-7668-f0e1-0638-c3be3237e812@2ndquadrant.com
2020-04-02 02:31:24 Tomas Vondra (fuzzycz) Created patch record
Edit