Re: PATCH: index-only scans with partial indexes

From:	David Steele <david(at)pgmasters(dot)net>
To:	Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>, tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc:	tomas(dot)vondra(at)2ndquadrant(dot)com, kgrittn(at)ymail(dot)com, simon(at)2ndquadrant(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject:	Re: PATCH: index-only scans with partial indexes
Date:	2016-03-16 16:13:07
Message-ID:	56E98613.5000003@pgmasters.net
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2015-07-10 18:29:43 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> 📎  2015-07-10 20:43:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2015-07-11 12:00:53 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>  2015-08-25 17:19:32 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>   2015-09-04 11:28:29 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru>    2015-09-04 16:10:47 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>     2015-09-04 21:03:31 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> 📎      2015-09-05 08:53:12 from Simon Riggs <simon(at)2ndQuadrant(dot)com>       2015-09-05 17:17:41 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>        2015-09-13 18:03:06 from Kevin Grittner <kgrittn(at)ymail(dot)com>         2015-09-13 21:21:30 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>          2015-09-14 07:35:50 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>           2015-09-14 08:00:24 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>            2015-09-14 10:09:01 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> 📎             2015-09-14 10:15:32 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>              2015-09-14 10:51:19 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>               2015-09-14 11:27:47 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                2015-09-17 10:45:53 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>                 2015-09-17 15:40:27 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                  2015-09-18 01:46:10 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>                   2015-09-26 11:28:52 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> 📎                    2015-09-26 16:00:33 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> 📎                     2015-09-29 10:27:22 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>                      2015-09-29 14:57:03 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                       2015-09-29 16:56:45 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> 📎                        2015-09-30 08:29:41 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>                         2015-09-30 10:55:40 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                          2015-09-30 23:36:51 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> 📎                           2015-10-06 06:12:02 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> 📎                            2015-10-08 05:30:29 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> 📎                             2015-10-08 13:24:35 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                              2015-10-09 00:59:30 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>                               2015-10-09 14:32:31 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                                2015-10-14 06:06:30 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>                                 2015-12-06 22:48:51 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                                  2015-12-24 03:05:09 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                   2015-12-24 03:29:47 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                                    2016-01-31 12:34:35 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                     2016-01-31 15:44:05 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>                                      2016-01-31 22:11:38 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                       2016-02-03 07:37:21 from Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>                                  2016-02-24 00:13:22 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> 📎                                   2016-02-25 10:56:59 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>                                    2016-02-25 11:22:45 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                                     2016-02-26 06:01:41 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>                                      2016-02-26 07:06:37 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> 📎                                       2016-02-26 07:18:26 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>                                        2016-02-26 12:46:18 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                         2016-02-26 16:08:54 from Robert Haas <robertmhaas(at)gmail(dot)com>                                          2016-02-27 12:49:07 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>                                           2016-02-27 14:58:31 from Robert Haas <robertmhaas(at)gmail(dot)com>                                       2016-03-08 23:08:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                        2016-03-09 08:29:49 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> 📎                                         2016-03-09 08:35:10 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>                                         2016-03-16 16:13:07 from David Steele <david(at)pgmasters(dot)net>                                          2016-03-17 08:18:51 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>                                         2016-03-20 16:00:08 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> 📎                                          2016-03-29 18:31:19 from Kevin Grittner <kgrittn(at)gmail(dot)com> 📎                                           2016-03-30 04:01:03 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>                                            2016-03-30 13:40:24 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                                             2016-03-30 15:49:24 from Kevin Grittner <kgrittn(at)gmail(dot)com>                                             2016-03-31 09:17:55 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>                                           2016-03-30 23:36:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                            2016-03-31 06:42:50 from Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>                                             2016-03-31 12:53:58 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> 📎                                              2016-03-31 18:51:02 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                               2016-04-01 02:39:49 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>                       2015-09-30 01:54:40 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>
Lists:	pgsql-hackers

In response to

• Re: PATCH: index-only scans with partial indexes at 2016-03-09 08:29:49 from Kyotaro HORIGUCHI

Responses

• Re: PATCH: index-only scans with partial indexes at 2016-03-17 08:18:51 from Kyotaro HORIGUCHI

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Robert Haas	2016-03-16 16:16:30	Re: Choosing parallel_degree
Previous Message	Robert Haas	2016-03-16 16:12:45	Re: Re: [COMMITTERS] pgsql: Only try to push down foreign joins if the user mapping OIDs mat