Quick Links

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

From:	Andres Freund <andres(at)anarazel(dot)de>
To:	Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>
Cc:	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-03-22 01:41:33
Message-ID:	20220322014133.ktc2ffeb2m3jamgh@alap3.anarazel.de
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-hackers

Hi,

On 2022-03-08 21:44:37 +0800, Andy Fan wrote:
> I have finished the PoC for planning timing improvement and joinrel rows
> estimation.

As this is clearly not 15 material, I've set the target version as 16. But it
might be good to just move the whole entry to the next CF...

Greetings,

Andres Freund

	From	Date	Subject
Next Message	Fabrízio de Royes Mello	2022-03-22 01:44:33	Re: speed up a logical replica setup
Previous Message	Andres Freund	2022-03-22 01:34:09	Re: MDAM techniques and Index Skip Scan patch