Re: Question on partition pruning involving stable operator: timestamptz_ge_date

Hi, On Thu, Jan 27, 2022 at 10:28 AM TAO TANG wrote: > the plan shows all the partitions are pruned, but in gdb tracing, it shows > that > the pruning happens in ExecInitAppend, and during planning stage pg does not > prune any partitions. this is because in function > match_clause_to_partition

Question on partition pruning involving stable operator: timestamptz_ge_date

Hi, I tested the following case in PostgreSQL master:58e2e6 the partition table created: create table tbl_dts (dts timestamp with time zone not null) partition by range(dts); create table tbl_dts_1 partition of tbl_dts for values from ('2021-07-02') to ('2021-08-01'); create table tb