Date: Mon, 21 Mar 2022 18:41:33 -0700
From: Andres Freund <andres@anarazel.de>
To: Andy Fan <zhihui.fan1213@gmail.com>
Cc: Robert Haas <robertmhaas@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>,
	David Rowley <dgrowleyml@gmail.com>,
	Dmitry Astapov <dastapov@gmail.com>,
	PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: Condition pushdown: why (=) is pushed down into join, but
 BETWEEN or >= is not?
Message-ID: <20220322014133.ktc2ffeb2m3jamgh@alap3.anarazel.de>
References: <CA+TgmoZ89OpOCzXebNppQrU_wtQYimkHY3q3rWnS6ZmihA92+A@mail.gmail.com>
 <CAKU4AWr_9rq_dqa=SaRL8QaL=z4LJAuL5wqtY4U82=ts14v7dw@mail.gmail.com>
 <CA+TgmoZSJpZY78Etvyc-xrZ+acjGWDCyr7mjLQbQWB2U_gyHZg@mail.gmail.com>
 <2889422.1646175214@sss.pgh.pa.us>
 <CA+TgmoZreVw+JomzAOz7h0XdPDJZLS7As648f9MjM3wMm8OCUw@mail.gmail.com>
 <2908648.1646186702@sss.pgh.pa.us>
 <CA+Tgmoax5_Yo0ggznZBLnFDhq9eh3L+JWyipzZe2905zkFm3GA@mail.gmail.com>
 <3001201.1646237367@sss.pgh.pa.us>
 <CA+TgmoZvfuO077b2wdXAaqjHqtxXt4MhQ9e7B=eJuC2vepU3EA@mail.gmail.com>
 <CAKU4AWpFTa2cW3grXeRedoHD5cd0U9itUhou6CRYBcJTpU4kEQ@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <CAKU4AWpFTa2cW3grXeRedoHD5cd0U9itUhou6CRYBcJTpU4kEQ@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/20220322014133.ktc2ffeb2m3jamgh%40alap3.anarazel.de>
Precedence: bulk

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.

This currently crashes on cfbot:
https://api.cirrus-ci.com/v1/task/6158455839916032/logs/cores.log
https://cirrus-ci.com/task/6158455839916032

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