BRIN multi-minmax and bloom indexes

Edit

Title

Topic

Performance

Created

2020-04-02 02:31:24

Last modified

2021-03-26 13:09:17 (8 months, 1 week ago)

Latest email

2021-03-27 20:42:05 (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

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