Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx> 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
