Speed up match_eclasses_to_foreign_key_col() when there are many ECs.
Tom Lane <tgl@sss.pgh.pa.us>
Speed up match_eclasses_to_foreign_key_col() when there are many ECs. Check ec_relids before bothering to iterate through the EC members. On a perhaps extreme, but still real-world, query in which match_eclasses_to_foreign_key_col() accounts for the bulk of the planner's runtime, this saves nearly 40% of the runtime. It's a bit of a stopgap fix, but it's simple enough to be back-patched to 9.6 where this code came in; so let's do that. David Rowley Discussion: https://postgr.es/m/6970.1545327857@sss.pgh.pa.us
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/optimizer/path/equivclass.c | modified | +8 −0 |
Discussion
- Performance issue in foreign-key-aware join estimation 30 messages · 2018-12-20 → 2019-07-21