Re: [HACKERS] [WIP] Effective storage of duplicates in B-tree index.

From:	Peter Geoghegan <pg(at)bowt(dot)ie>
To:	Andres Freund <andres(at)anarazel(dot)de>
Cc:	Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Юрий Соколов <funny(dot)falcon(at)gmail(dot)com>
Subject:	Re: [HACKERS] [WIP] Effective storage of duplicates in B-tree index.
Date:	2020-03-06 19:01:19
Message-ID:	CAH2-Wzk=kLH-rKfvFRdFU=Ct5qynJFzRPBLKtMaqphthAZu_TA@mail.gmail.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2015-08-31 07:41:15 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru>  2015-08-31 15:26:53 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>   2015-09-01 09:31:54 from Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>    2015-09-01 15:41:43 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>    2019-09-15 10:47:15 from Oleg Bartunov <obartunov(at)postgrespro(dot)ru>     2019-11-16 02:18:49 from Peter Geoghegan <pg(at)bowt(dot)ie>  2015-09-01 18:23:44 from Peter Geoghegan <pg(at)heroku(dot)com>   2015-09-03 15:35:13 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru>    2015-09-27 23:11:51 from Peter Geoghegan <pg(at)heroku(dot)com>     2015-09-27 23:23:39 from Peter Geoghegan <pg(at)heroku(dot)com>  2016-01-28 14:06:57 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru> 📎   2016-01-28 15:12:36 from Thom Brown <thom(at)linux(dot)com>    2016-01-28 16:12:54 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru> 📎     2016-01-28 17:03:02 from Thom Brown <thom(at)linux(dot)com>      2016-01-28 17:09:36 from Peter Geoghegan <pg(at)heroku(dot)com>       2016-01-28 17:14:10 from Thom Brown <thom(at)linux(dot)com>      2016-01-28 20:32:38 from Thom Brown <thom(at)linux(dot)com>      2016-01-29 13:46:24 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru>       2016-01-29 15:47:33 from Aleksander Alekseev <a(dot)alekseev(at)postgrespro(dot)ru>        2016-01-29 16:01:37 from Thom Brown <thom(at)linux(dot)com>         2016-01-29 16:50:46 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru> 📎          2016-01-29 17:43:02 from Thom Brown <thom(at)linux(dot)com>           2016-02-02 11:47:29 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru>            2016-02-02 11:59:21 from Thom Brown <thom(at)linux(dot)com>             2016-02-04 15:07:36 from Peter Geoghegan <pg(at)heroku(dot)com>              2016-02-04 16:25:55 from Thom Brown <thom(at)linux(dot)com>               2016-02-04 16:27:25 from Peter Geoghegan <pg(at)heroku(dot)com>          2016-02-04 17:16:46 from Peter Geoghegan <pg(at)heroku(dot)com>           2016-02-18 17:18:25 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru> 📎            2016-02-18 17:29:36 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru> 📎             2016-03-14 13:02:06 from David Steele <david(at)pgmasters(dot)net>              2016-03-15 17:36:52 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru>               2016-03-18 17:19:37 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru> 📎                2016-03-23 15:30:14 from Alexandr Popov <a(dot)popov(at)postgrespro(dot)ru>                2016-03-24 14:17:23 from Robert Haas <robertmhaas(at)gmail(dot)com>                 2016-03-24 15:21:29 from Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>                  2016-03-25 00:22:49 from Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>                 2016-03-24 22:12:45 from Peter Geoghegan <pg(at)heroku(dot)com>                  2016-03-28 14:29:53 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru>                  2016-03-28 17:28:22 from Claudio Freire <klaussfreire(at)gmail(dot)com>                2016-07-04 09:30:05 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi>                 2016-11-07 00:02:42 from Peter Geoghegan <pg(at)heroku(dot)com>                2019-07-04 12:06:38 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru> 📎                 2019-07-04 17:38:21 from Peter Geoghegan <pg(at)bowt(dot)ie>                  2019-07-05 00:06:09 from Peter Geoghegan <pg(at)bowt(dot)ie>                   2019-07-05 18:52:27 from Bruce Momjian <bruce(at)momjian(dot)us>                 2019-07-06 23:08:21 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                  2019-07-11 04:53:04 from Peter Geoghegan <pg(at)bowt(dot)ie>                   2019-07-11 14:30:30 from Bruce Momjian <bruce(at)momjian(dot)us>                    2019-07-11 17:20:17 from Peter Geoghegan <pg(at)bowt(dot)ie>                   2019-07-11 15:08:58 from Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>                    2019-07-11 17:51:23 from Peter Geoghegan <pg(at)bowt(dot)ie>                  2019-07-11 15:02:04 from Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>                   2019-07-11 17:42:55 from Peter Geoghegan <pg(at)bowt(dot)ie>                    2019-07-12 01:47:14 from Peter Geoghegan <pg(at)bowt(dot)ie>                  2019-07-11 15:34:42 from Rafia Sabih <rafia(dot)pghackers(at)gmail(dot)com>                   2019-07-11 18:19:46 from Peter Geoghegan <pg(at)bowt(dot)ie>                    2019-07-17 16:36:27 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru> 📎                     2019-07-19 17:53:22 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru> 📎                      2019-07-19 19:32:18 from Peter Geoghegan <pg(at)bowt(dot)ie>                       2019-07-20 02:24:48 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                        2019-07-24 01:22:01 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                         2019-07-24 22:06:13 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                          2019-07-25 03:48:59 from Peter Geoghegan <pg(at)bowt(dot)ie>                           2019-07-31 14:59:22 from Rafia Sabih <rafia(dot)pghackers(at)gmail(dot)com>                         2019-07-31 16:22:59 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru> 📎                          2019-08-06 01:28:18 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                           2019-08-13 15:45:15 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru> 📎                            2019-08-16 15:56:12 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru> 📎                             2019-08-20 01:04:18 from Peter Geoghegan <pg(at)bowt(dot)ie>                              2019-08-21 17:19:38 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru> 📎                               2019-08-23 04:33:41 from Peter Geoghegan <pg(at)bowt(dot)ie>                                2019-08-23 11:45:47 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru>                             2019-08-28 03:19:43 from Peter Geoghegan <pg(at)bowt(dot)ie>                              2019-08-29 12:13:39 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru> 📎                               2019-08-30 00:07:53 from Peter Geoghegan <pg(at)bowt(dot)ie>                                2019-08-30 05:10:14 from Peter Geoghegan <pg(at)bowt(dot)ie>                                 2019-08-31 08:04:01 from Peter Geoghegan <pg(at)bowt(dot)ie>                                  2019-09-03 01:53:09 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                                   2019-09-09 19:54:08 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                                    2019-09-11 12:37:59 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru> 📎                                     2019-09-11 21:04:59 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                                      2019-09-13 01:04:25 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                                       2019-09-16 15:48:44 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru> 📎                                        2019-09-16 18:58:50 from Peter Geoghegan <pg(at)bowt(dot)ie>                                         2019-09-16 21:11:29 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                                         2019-09-17 16:43:35 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru> 📎                                          2019-09-18 17:43:18 from Peter Geoghegan <pg(at)bowt(dot)ie>                                           2019-09-18 18:01:19 from Peter Geoghegan <pg(at)bowt(dot)ie>                                           2019-09-19 02:25:23 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                                            2019-09-24 00:13:32 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                                             2019-09-24 19:41:04 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                                             2019-09-25 15:05:03 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru> 📎                                              2019-09-25 19:14:08 from Peter Geoghegan <pg(at)bowt(dot)ie>                                               2019-09-27 16:43:08 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru> 📎                                                2019-09-28 02:02:15 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                 2019-10-01 02:39:34 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                                                  2019-10-02 17:43:51 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                  2019-11-04 19:52:14 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                                                   2019-11-08 18:35:57 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                                                    2019-11-12 23:21:53 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                                                     2019-11-13 19:33:38 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                      2019-11-13 19:51:18 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                       2019-11-15 13:16:22 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                        2019-11-16 00:04:44 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                         2019-11-16 13:46:02 from Te <nospam-abuse(at)bloodgate(dot)com>                                                       2019-11-16 01:43:39 from Mark Dilger <hornschnorter(at)gmail(dot)com>                                                        2019-11-16 02:03:01 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                     2019-12-03 20:13:54 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                      2019-12-05 00:54:58 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                                                      2019-12-13 02:21:20 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                                                       2019-12-17 21:58:25 from Bruce Momjian <bruce(at)momjian(dot)us>                                                        2019-12-17 23:30:33 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                         2019-12-18 01:17:58 from Bruce Momjian <bruce(at)momjian(dot)us>                                                          2019-12-18 01:29:27 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                       2019-12-18 03:27:39 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                        2019-12-20 02:55:52 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                                                         2020-01-04 01:47:01 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                                                          2020-01-08 13:56:23 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi> 📎                                                           2020-01-08 22:56:22 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                            2020-01-10 21:36:00 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                                                             2020-01-14 00:07:40 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                             2020-01-15 02:08:57 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                                                              2020-01-29 01:29:05 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                                                               2020-02-07 02:18:20 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                                                                2020-02-14 02:57:47 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                                                                 2020-02-19 16:14:03 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru>                                                                  2020-02-19 19:16:12 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                                   2020-02-20 01:08:10 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                                   2020-02-20 15:38:22 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru>                                                                    2020-02-20 18:58:29 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                                     2020-02-20 20:59:43 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                                      2020-02-25 00:54:53 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                                                                       2020-02-26 22:43:27 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                                        2020-02-27 06:03:07 from Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>                                                                         2020-02-27 17:33:42 from Peter Geoghegan <pg(at)bowt(dot)ie>                                                                        2020-03-06 17:33:54 from Andres Freund <andres(at)anarazel(dot)de>                                                                         2020-03-06 19:01:19 from Peter Geoghegan <pg(at)bowt(dot)ie>                                      2019-11-16 01:02:09 from Peter Geoghegan <pg(at)bowt(dot)ie>                                       2019-11-19 01:26:37 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                                        2019-11-25 08:10:55 from Michael Paquier <michael(at)paquier(dot)xyz>                                        2019-11-27 01:28:50 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                                     2019-09-11 22:09:33 from Peter Geoghegan <pg(at)bowt(dot)ie>                                      2019-09-12 00:56:44 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎                            2019-08-20 00:52:05 from Peter Geoghegan <pg(at)bowt(dot)ie>
Lists:	pgsql-hackers

In response to

• Re: [HACKERS] [WIP] Effective storage of duplicates in B-tree index. at 2020-03-06 17:33:54 from Andres Freund

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Andres Freund	2020-03-06 19:06:41	Re: Atomics in localbuf.c
Previous Message	Pavel Stehule	2020-03-06 18:54:35	Re: proposal: schema variables