Hello list,
Is runtime partition pruning available in PostgreSQL 12?
I have a table partitioned by range on column id (primary key).
For the query (client_id is passed as a parameter from the application):
I have a table partitioned by range on column id (primary key).
For the query (client_id is passed as a parameter from the application):
select * from test where id between>0 and and id<1000 and client_id=? ;
partition pruning works fine.
However
However
select * from test where id between client_id-10 and client_id+10 and client_id=?;
does not (it scans all partitions in parallel) .
Is it expected?
Regards,
Radu
