Re: POC, WIP: OR-clause support for indexes

From:	Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>
To:	jian he <jian(dot)universality(at)gmail(dot)com>
Cc:	Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru>, Alexander Korotkov <aekorotkov(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org, Peter Geoghegan <pg(at)bowt(dot)ie>, "Finnerty, Jim" <jfinnert(at)amazon(dot)com>, Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>, teodor(at)sigaev(dot)ru, Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>, Peter Eisentraut <peter(at)eisentraut(dot)org>, Ranier Vilela <ranier(dot)vf(at)gmail(dot)com>
Subject:	Re: POC, WIP: OR-clause support for indexes
Date:	2024-03-05 07:59:16
Message-ID:	d5d3f257-a2d8-4776-9c97-83f98e74636c@postgrespro.ru
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2015-12-26 18:04:58 from Teodor Sigaev <teodor(at)sigaev(dot)ru> 📎  2015-12-26 18:40:02 from Feng Tian <ftian(at)vitessedata(dot)com>   2015-12-26 19:25:19 from Teodor Sigaev <teodor(at)sigaev(dot)ru>  2016-01-11 03:16:23 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>   2016-01-28 11:16:04 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>   2016-02-29 18:04:38 from Teodor Sigaev <teodor(at)sigaev(dot)ru> 📎    2016-03-10 13:04:37 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>     2016-03-17 17:19:55 from Teodor Sigaev <teodor(at)sigaev(dot)ru> 📎      2016-03-20 00:44:37 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>       2016-03-25 15:13:26 from David Steele <david(at)pgmasters(dot)net>        2016-03-29 14:01:21 from David Steele <david(at)pgmasters(dot)net>     2016-03-18 16:38:05 from Teodor Sigaev <teodor(at)sigaev(dot)ru> 📎      2016-03-18 23:46:26 from Andreas Karlsson <andreas(at)proxel(dot)se>  2022-12-28 04:19:27 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎   2023-01-14 15:13:54 from Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru>    2023-01-14 15:45:27 from Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>     2023-06-26 01:47:43 from Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru> 📎      2023-06-26 02:38:14 from Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru> 📎      2023-06-26 03:18:37 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎       2023-06-27 13:19:48 from Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru> 📎        2023-06-27 15:49:20 from Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru> 📎        2023-06-27 19:50:37 from Peter Geoghegan <pg(at)bowt(dot)ie>         2023-06-29 09:32:51 from Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru> 📎          2023-06-29 09:55:58 from Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru>           2023-06-29 11:23:22 from Ranier Vilela <ranier(dot)vf(at)gmail(dot)com>            2023-06-29 15:16:50 from Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru>           2023-07-05 19:39:08 from Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru> 📎            2023-07-05 20:06:26 from Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru> 📎             2023-07-06 10:20:46 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎              2023-07-07 08:20:20 from Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru> 📎               2023-07-10 03:12:23 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                2023-07-10 08:38:17 from Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru> 📎                 2023-07-10 12:03:59 from Ranier Vilela <ranier(dot)vf(at)gmail(dot)com>                  2023-07-10 12:15:51 from Ranier Vilela <ranier(dot)vf(at)gmail(dot)com>                   2023-07-11 12:29:21 from Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru> 📎                    2023-07-11 13:29:14 from Ranier Vilela <ranier(dot)vf(at)gmail(dot)com>                     2023-07-11 14:13:05 from Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru> 📎                 2023-07-11 08:47:45 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                  2023-07-11 18:11:31 from Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru> 📎                   2023-07-18 14:25:28 from Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru> 📎             2023-07-07 02:43:26 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎          2023-07-25 23:47:41 from Peter Geoghegan <pg(at)bowt(dot)ie>           2023-07-26 22:30:00 from Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru>            2023-07-29 16:15:10 from Peter Geoghegan <pg(at)bowt(dot)ie>             2023-07-31 16:38:23 from Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru>              2023-08-01 19:42:18 from Peter Geoghegan <pg(at)bowt(dot)ie>               2023-08-01 20:11:07 from "Finnerty, Jim" <jfinnert(at)amazon(dot)com>                2023-08-01 21:16:09 from Peter Geoghegan <pg(at)bowt(dot)ie>               2023-08-02 15:58:37 from Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru> 📎                2023-08-02 18:58:11 from Peter Geoghegan <pg(at)bowt(dot)ie>                 2023-08-03 19:47:44 from Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru>                  2023-08-06 02:01:14 from Peter Geoghegan <pg(at)bowt(dot)ie>                   2023-08-06 21:43:08 from Peter Geoghegan <pg(at)bowt(dot)ie>                   2023-08-09 11:33:31 from Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru>                    2023-08-17 10:08:03 from "a(dot)rybakina" <a(dot)rybakina(at)postgrespro(dot)ru> 📎                     2023-08-17 10:20:33 from "a(dot)rybakina" <a(dot)rybakina(at)postgrespro(dot)ru> 📎                     2023-08-20 22:11:24 from Peter Geoghegan <pg(at)bowt(dot)ie>                      2023-08-20 22:26:32 from Peter Geoghegan <pg(at)bowt(dot)ie>                       2023-08-29 03:37:51 from "a(dot)rybakina" <a(dot)rybakina(at)postgrespro(dot)ru>                        2023-09-20 09:37:05 from Peter Eisentraut <peter(at)eisentraut(dot)org>                         2023-09-20 12:06:35 from "a(dot)rybakina" <a(dot)rybakina(at)postgrespro(dot)ru>                          2023-09-26 09:08:52 from "a(dot)rybakina" <a(dot)rybakina(at)postgrespro(dot)ru> 📎                          2023-09-26 09:13:29 from "a(dot)rybakina" <a(dot)rybakina(at)postgrespro(dot)ru> 📎                          2023-09-26 09:21:10 from "a(dot)rybakina" <a(dot)rybakina(at)postgrespro(dot)ru> 📎                           2023-09-26 09:39:02 from "a(dot)rybakina" <a(dot)rybakina(at)postgrespro(dot)ru>                           2023-09-29 17:35:13 from "a(dot)rybakina" <a(dot)rybakina(at)postgrespro(dot)ru> 📎                            2023-10-04 19:19:59 from "a(dot)rybakina" <a(dot)rybakina(at)postgrespro(dot)ru> 📎                             2023-10-14 22:34:51 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                              2023-10-15 23:21:39 from "a(dot)rybakina" <a(dot)rybakina(at)postgrespro(dot)ru>                              2023-10-25 11:04:24 from "a(dot)rybakina" <a(dot)rybakina(at)postgrespro(dot)ru> 📎                              2023-10-25 19:54:12 from Robert Haas <robertmhaas(at)gmail(dot)com>                               2023-10-26 19:47:20 from Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru>                                2023-10-26 19:58:47 from Robert Haas <robertmhaas(at)gmail(dot)com>                                 2023-10-26 20:41:54 from Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru>                                 2023-10-26 21:04:44 from Peter Geoghegan <pg(at)bowt(dot)ie>                                  2023-10-29 16:41:06 from Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru>                                  2023-10-30 13:40:11 from Robert Haas <robertmhaas(at)gmail(dot)com>                                   2023-10-30 14:06:41 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                    2023-11-06 13:51:45 from Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru> 📎                                     2023-11-10 09:20:57 from Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru> 📎                                      2023-11-13 19:48:23 from "a(dot)rybakina" <a(dot)rybakina(at)postgrespro(dot)ru> 📎                                       2023-11-25 01:13:47 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                        2023-11-25 11:10:18 from Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru>                                         2023-11-25 16:13:18 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                          2023-11-28 03:52:20 from Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru> 📎                                      2023-11-20 08:52:08 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                       2023-11-20 09:29:47 from "a(dot)rybakina" <a(dot)rybakina(at)postgrespro(dot)ru>                                       2023-11-21 00:50:15 from Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru> 📎                                        2023-11-21 11:31:11 from Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru> 📎                                         2023-11-23 09:23:20 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                          2023-11-24 03:30:39 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                           2023-11-24 05:05:14 from Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru>                                            2023-11-25 01:23:38 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                             2023-11-27 08:02:09 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                              2023-11-27 21:03:50 from Robert Haas <robertmhaas(at)gmail(dot)com>                                               2023-11-27 22:15:48 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                2023-11-28 00:06:35 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                                                2023-11-28 00:07:18 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                 2023-11-28 01:07:46 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                  2023-11-28 03:56:34 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                  2023-11-28 12:52:02 from Robert Haas <robertmhaas(at)gmail(dot)com>                                               2023-11-28 11:46:51 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                2023-11-30 08:00:28 from Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru>                                                 2023-11-30 08:05:31 from Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru> 📎                                                 2023-11-30 08:30:28 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                                  2023-11-30 09:00:41 from Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru>                                                 2023-11-30 10:57:26 from Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru> 📎                                                  2023-12-04 06:50:34 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                   2023-12-05 10:55:00 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                    2024-01-27 02:58:53 from vignesh C <vignesh21(at)gmail(dot)com>                                                    2024-01-30 14:15:20 from jian he <jian(dot)universality(at)gmail(dot)com>                                                     2024-01-31 02:55:56 from jian he <jian(dot)universality(at)gmail(dot)com>                                                      2024-01-31 10:15:00 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                                       2024-01-31 11:10:44 from Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru>                                                        2024-02-01 05:00:00 from jian he <jian(dot)universality(at)gmail(dot)com>                                                         2024-02-02 19:06:17 from Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru> 📎                                                          2024-02-08 05:34:38 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                           2024-02-10 05:00:00 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                                            2024-02-12 05:52:13 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                             2024-02-12 08:55:40 from Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru>                                                              2024-02-12 09:01:50 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                                               2024-02-12 10:51:45 from Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru>                                                                2024-02-13 10:43:21 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                           2024-02-13 00:00:00 from jian he <jian(dot)universality(at)gmail(dot)com>                                                            2024-02-13 10:03:20 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                                             2024-02-14 03:21:41 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                                              2024-02-16 00:00:00 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                                               2024-02-16 05:32:36 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                                                2024-02-16 12:54:16 from jian he <jian(dot)universality(at)gmail(dot)com>                                                                 2024-02-19 08:35:19 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                                  2024-02-19 12:53:26 from Ranier Vilela <ranier(dot)vf(at)gmail(dot)com>                                                                   2024-02-20 03:18:23 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                                    2024-02-20 11:17:07 from Ranier Vilela <ranier(dot)vf(at)gmail(dot)com>                                                                     2024-02-24 11:28:01 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                                                      2024-02-26 04:10:47 from Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru> 📎                                                                       2024-02-28 04:18:59 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                                                        2024-02-28 10:07:21 from jian he <jian(dot)universality(at)gmail(dot)com>                                                                         2024-02-28 10:27:41 from Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru>                                                                          2024-02-29 08:59:23 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                                           2024-03-01 15:33:05 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                            2024-03-03 09:26:19 from Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru>                                                                             2024-03-03 09:48:19 from Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru>                                                                            2024-03-04 04:31:03 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                                                           2024-03-04 02:26:48 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                                                            2024-03-05 05:30:25 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                                                             2024-03-05 07:59:16 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                                              2024-03-07 14:51:43 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                                               2024-03-07 20:28:59 from Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru> 📎                                                                                2024-03-09 00:00:00 from jian he <jian(dot)universality(at)gmail(dot)com>                                                                               2024-03-11 05:13:02 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                                                                2024-03-11 11:31:12 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                 2024-03-11 12:43:39 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                                                                  2024-03-12 15:20:12 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                   2024-03-13 05:52:50 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                                                    2024-03-13 11:05:41 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                     2024-03-13 12:16:09 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                                                                      2024-03-14 09:31:58 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                       2024-03-14 10:11:15 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                                                        2024-03-14 10:39:42 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                         2024-03-15 05:05:02 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                                                       2024-03-19 05:16:59 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                                                        2024-03-28 13:54:57 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                         2024-04-01 06:37:58 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                                                          2024-04-07 22:34:37 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                                           2024-04-08 00:38:36 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                         2024-02-29 01:50:06 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                                                  2024-02-20 04:03:31 from jian he <jian(dot)universality(at)gmail(dot)com>                                                                   2024-02-20 04:29:36 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                   2023-10-30 16:01:29 from Peter Geoghegan <pg(at)bowt(dot)ie>                     2023-08-20 22:42:39 from Peter Geoghegan <pg(at)bowt(dot)ie>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v19-0001-Transform-OR-clauses-to-ANY-expression.patch	text/plain	60.9 KB
v19-0002-Teach-generate_bitmap_or_paths-to-build-BitmapOr-pat.patch	text/plain	33.7 KB

In response to

• Re: POC, WIP: OR-clause support for indexes at 2024-03-05 05:30:25 from Andrei Lepikhov

Responses

• Re: POC, WIP: OR-clause support for indexes at 2024-03-07 14:51:43 from Alexander Korotkov

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Sutou Kouhei	2024-03-05 08:18:08	Re: Make COPY format extendable: Extract COPY TO format implementations
Previous Message	Heikki Linnakangas	2024-03-05 07:55:32	Re: Missing LWLock protection in pgstat_reset_replslot()