Re: Condition pushdown: why (=) is pushed down into join, but BETWEEN or >= is not?

From:	Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
To:	Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>
Cc:	Andres Freund <andres(at)anarazel(dot)de>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, David Rowley <dgrowleyml(at)gmail(dot)com>, Dmitry Astapov <dastapov(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: Condition pushdown: why (=) is pushed down into join, but BETWEEN or >= is not?
Date:	2022-05-16 22:51:52
Message-ID:	CA+hUKGJ-yT8GM-qCnDzgcJzGptoc9FvG27+3k4NaN02-DfSuxg@mail.gmail.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2021-05-12 10:41:20 from Dmitry Astapov <dastapov(at)gmail(dot)com>  2021-05-12 15:54:06 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2021-05-12 17:56:00 from Dmitry Astapov <dastapov(at)gmail(dot)com>    2021-05-13 23:21:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2021-05-14 04:21:52 from David Rowley <dgrowleyml(at)gmail(dot)com>      2022-02-01 15:07:41 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> 📎       2022-02-01 17:13:29 from Justin Pryzby <pryzby(at)telsasoft(dot)com>        2022-02-02 07:37:13 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>         2022-02-05 13:32:40 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>          2022-02-06 02:23:28 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>           2022-02-11 05:32:20 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> 📎            2022-02-11 10:37:17 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>             2022-02-17 18:55:06 from "Finnerty, Jim" <jfinnert(at)amazon(dot)com>       2022-02-17 20:15:13 from Robert Haas <robertmhaas(at)gmail(dot)com>        2022-02-17 21:17:36 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>         2022-02-17 22:16:31 from Robert Haas <robertmhaas(at)gmail(dot)com>          2022-02-19 00:16:53 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>           2022-02-21 07:46:07 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>        2022-02-18 05:56:05 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>         2022-02-18 18:27:16 from Robert Haas <robertmhaas(at)gmail(dot)com>          2022-02-21 07:31:22 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>           2022-03-01 21:50:08 from Robert Haas <robertmhaas(at)gmail(dot)com>            2022-03-01 22:53:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>             2022-03-02 01:11:24 from Robert Haas <robertmhaas(at)gmail(dot)com>              2022-03-02 02:05:02 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>               2022-03-02 15:46:15 from Robert Haas <robertmhaas(at)gmail(dot)com>                2022-03-02 16:09:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                 2022-03-02 17:29:06 from Robert Haas <robertmhaas(at)gmail(dot)com>                  2022-03-08 13:44:37 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> 📎                   2022-03-17 03:13:15 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>                   2022-03-22 01:41:33 from Andres Freund <andres(at)anarazel(dot)de>                    2022-03-24 02:21:41 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> 📎                     2022-05-16 22:51:52 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>                      2022-05-17 02:00:35 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>                       2022-07-07 11:11:06 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                        2022-11-04 03:02:39 from Ian Lawrence Barwick <barwick(at)gmail(dot)com>                         2022-11-08 09:04:00 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>              2022-03-02 03:00:12 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>             2022-03-02 02:43:15 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>     2021-05-17 02:52:22 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>      2021-05-19 12:14:47 from David Rowley <dgrowleyml(at)gmail(dot)com>       2021-05-20 05:21:42 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>
Lists:	pgsql-hackers

In response to

• Re: Condition pushdown: why (=) is pushed down into join, but BETWEEN or >= is not? at 2022-03-24 02:21:41 from Andy Fan

Responses

• Re: Condition pushdown: why (=) is pushed down into join, but BETWEEN or >= is not? at 2022-05-17 02:00:35 from Andy Fan

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	David Rowley	2022-05-16 23:26:04	Re: Avoid unecessary MemSet call (src/backend/utils/cache/relcache.c)
Previous Message	David Rowley	2022-05-16 20:02:37	Re: weird comments in Memoize nodes