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): select * from test where id between>0 and and id<1000 and client_id=? ; partition pruning works fine. 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
