Re: Performance improvement for joins where outer side is unique

From:	Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To:	David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
Cc:	Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: Performance improvement for joins where outer side is unique
Date:	2016-03-04 21:43:01
Message-ID:	20160304214301.GA743771@alvherre.pgsql
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2014-12-31 13:47:49 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎  2015-01-30 11:37:19 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎   2015-02-03 09:23:36 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>    2015-02-27 06:23:26 from David Rowley <dgrowleyml(at)gmail(dot)com>     2015-03-10 06:19:31 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>      2015-03-10 12:32:24 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎       2015-03-13 07:34:20 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>        2015-03-14 01:51:49 from David Rowley <dgrowleyml(at)gmail(dot)com>         2015-03-14 07:55:44 from David Rowley <dgrowleyml(at)gmail(dot)com>         2015-03-14 10:05:24 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎          2015-03-16 08:28:55 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>           2015-03-18 08:30:32 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> 📎            2015-03-20 03:11:40 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> 📎             2015-03-20 08:11:25 from David Rowley <dgrowleyml(at)gmail(dot)com>              2015-03-22 06:42:21 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎               2015-03-24 12:11:20 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> 📎                2015-03-28 07:35:00 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎                 2015-07-07 14:00:41 from Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>                  2015-07-08 00:29:38 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                   2015-08-06 13:36:21 from Uriy Zhuravlev <u(dot)zhuravlev(at)postgrespro(dot)ru>                    2015-08-06 14:45:28 from Erik Rijkers <er(at)xs4all(dot)nl>                     2015-08-23 19:31:43 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> 📎                      2015-08-23 23:35:54 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                       2015-08-24 00:19:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                        2015-08-24 00:50:13 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                         2015-08-24 02:29:37 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                          2015-08-25 05:25:53 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                           2015-08-26 07:44:06 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                           2015-09-03 16:50:37 from Robert Haas <robertmhaas(at)gmail(dot)com>                            2015-10-13 21:28:24 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                             2015-10-14 05:03:56 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>                              2015-10-14 19:57:48 from Robert Haas <robertmhaas(at)gmail(dot)com>                           2015-12-16 00:27:41 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                            2015-12-16 16:02:29 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                             2015-12-16 22:40:47 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                              2015-12-17 00:17:17 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                               2015-12-17 06:11:33 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                                2015-12-17 13:17:20 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                 2015-12-24 02:42:17 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                 2016-01-22 16:36:02 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> 📎                                  2016-01-22 20:42:40 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                   2016-02-18 09:19:08 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                   2016-03-04 21:43:01 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                    2016-03-06 00:14:29 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                  2016-03-08 23:57:09 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                   2016-03-09 00:19:40 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                    2016-03-09 00:38:52 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                     2016-03-09 01:39:18 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                     2016-03-11 21:32:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                      2016-03-11 22:43:10 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                       2016-03-12 10:56:47 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                        2016-03-12 14:44:20 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                                         2016-03-12 15:51:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                          2016-03-12 19:37:03 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                                           2016-03-12 20:01:11 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                                        2016-03-12 16:25:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                        2017-01-27 13:14:04 from Antonin Houska <ah(at)cybertec(dot)at>                                       2016-03-13 12:06:33 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                        2016-04-01 16:52:42 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                         2016-04-02 10:26:35 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                          2016-04-02 12:14:59 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                           2016-04-06 16:05:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                            2016-04-06 20:01:21 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                             2016-04-06 21:10:20 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                             2016-04-07 01:07:32 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                              2016-04-07 14:46:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                               2016-04-10 03:00:17 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                              2016-04-07 18:49:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                               2016-04-07 19:02:14 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                                2016-04-07 19:21:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                 2016-04-07 23:59:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 📎                                                  2016-04-09 11:27:20 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                  2016-04-10 03:30:35 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                               2016-10-31 05:37:09 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                                2016-11-02 02:21:28 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                                 2016-12-02 12:47:29 from Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com>                                                  2016-12-02 21:09:32 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                   2016-12-02 21:26:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                    2017-01-18 22:06:14 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                                     2017-01-18 23:29:15 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                                      2017-01-25 15:56:21 from Antonin Houska <ah(at)cybertec(dot)at>                                                       2017-01-26 11:39:26 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                                2017-01-24 17:27:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                 2017-01-26 11:37:20 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                                  2017-01-26 12:54:38 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                                   2017-01-26 19:34:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                    2017-01-26 21:15:35 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                                     2017-01-26 23:39:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                      2017-01-27 13:21:52 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                                       2017-01-27 16:04:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                        2017-01-27 16:44:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                         2017-01-27 17:15:40 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                          2017-01-27 18:39:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                           2017-01-27 18:44:28 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                            2017-01-27 19:00:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                             2017-01-27 19:29:17 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                         2017-01-31 00:10:02 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                                          2017-01-31 00:13:56 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                                           2017-02-02 03:16:06 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                                          2017-03-13 18:50:29 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                           2017-03-13 22:35:30 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                                            2017-03-14 05:37:24 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                                             2017-03-26 22:28:39 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                                              2017-03-27 02:51:03 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                                               2017-04-02 09:21:06 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                                                2017-04-02 11:19:09 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                2017-04-02 11:23:29 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                                                 2017-04-06 19:26:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                  2017-04-06 23:29:13 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                                                   2017-04-06 23:47:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                    2017-04-07 01:17:52 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                                                     2017-04-07 01:41:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                      2017-04-07 01:59:40 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> 📎                                                                       2017-04-08 02:23:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                        2017-04-09 08:53:34 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                                                2017-04-02 14:59:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                        2017-01-29 21:34:00 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                                         2017-01-30 15:56:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                          2017-01-30 21:32:50 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                                           2017-01-30 21:43:25 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                            2017-02-01 11:05:33 from David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>                                      2016-03-12 17:16:50 from Robert Haas <robertmhaas(at)gmail(dot)com>                                       2016-03-12 17:32:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2015-02-25 19:39:08 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>    2015-02-27 11:30:00 from David Rowley <dgrowleyml(at)gmail(dot)com>   2015-02-26 00:15:27 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>    2015-02-26 16:36:16 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>     2015-02-26 17:34:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>      2015-02-26 17:48:28 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>       2015-03-04 09:00:31 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎    2015-03-04 09:04:03 from David Rowley <dgrowleyml(at)gmail(dot)com>
Lists:	pgsql-hackers

In response to

• Re: Performance improvement for joins where outer side is unique at 2016-01-22 20:42:40 from David Rowley

Responses

• Re: Performance improvement for joins where outer side is unique at 2016-03-06 00:14:29 from David Rowley

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Julien Rouhaud	2016-03-04 21:52:03	Re: Publish autovacuum informations
Previous Message	Robert Haas	2016-03-04 20:58:28	Re: Default Roles