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, 8 months ago)

Latest email 2021-03-27 20:42:05 (3 years, 8 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