diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2019-02-20 20:53:08 -0500 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2019-02-20 20:53:08 -0500 |
commit | e22bfe94e4dfc9abedf17026c3081bca9877163d (patch) | |
tree | 9964b3a14f797ff4ad49b5ed8866ead531de7538 /src/backend/access/gist/gistsplit.c | |
parent | 93ec0c90cde7e0188c96bca9a8ba815b58c00d24 (diff) | |
download | postgresql-e22bfe94e4dfc9abedf17026c3081bca9877163d.tar.gz postgresql-e22bfe94e4dfc9abedf17026c3081bca9877163d.zip |
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
Diffstat (limited to 'src/backend/access/gist/gistsplit.c')
0 files changed, 0 insertions, 0 deletions