diff options
| author | Peter Eisentraut | 2017-02-18 00:32:15 +0000 |
|---|---|---|
| committer | Peter Eisentraut | 2017-02-18 00:32:15 +0000 |
| commit | e3a58c8835a2cd428b8534dd8df30a7cb96c976b (patch) | |
| tree | 94ca7efc1a9bd155b501f197ea810463498573db /src/backend/executor/execParallel.c | |
| parent | 68f3dbc5525a7e78290f7dee8a74f66d5fa738d6 (diff) | |
Optimize query for information_schema.constraint_column_usage
The way the old query was written prevented some join optimizations
because the join conditions were hidden inside a CASE expression. With
a large number of constraints, the query became unreasonably slow. The
new query performs much better.
From: Alexey Bashtanov <[email protected]>
Reviewed-by: Ashutosh Bapat <[email protected]>
Diffstat (limited to 'src/backend/executor/execParallel.c')
0 files changed, 0 insertions, 0 deletions