This thread teased me out of retirement ( albeit briefly ). Identical
plan_hash_values do NOT mean identical plans or ( by extension ) identical
performance. I’ve had a similar situation many years ago and it was ( who else
) Tanel who pointed out where in the plans the difference was despite identical
plan_hash_values!!!
What goes into the plan_hash_value is only a subset of what makes a plan!!!
On Oct 31, 2019, at 9:17 PM, Tanel Poder <tanel@xxxxxxxxxxxxxx> wrote:
The OP said that the plan hash value didn't change, but since the predicate
placement doesn't affect the hash value, it's worth confirming on which plan
lines the predicates are applied.