Scott Ribe <scott_ribe(at)elevated-dev(dot)com> writes:
> select * from tbl where txid > something and tbl_id = (select id from reftbl where name = 'someval');
> ^^^ fails to exclude partitions, kicks off parallel scans on all 142, takes 23,170ms
Why do you say this is a regression? From what I know of the partition
pruning logic (admittedly not a whole lot), I don't think we'd have
ever pruned on the basis of such a constraint.
regards, tom lane