forked frompostgres/postgres
- Notifications
You must be signed in to change notification settings - Fork6
Commitd54ca56
committed
Install a lookaside cache to speed up repeated lookups of the same operator
by short-circuiting schema search path and ambiguous-operator resolutioncomputations. Remarkably, this buys as much as 45% speedup of repetitivesimple queries that involve operators that are not an exact match to theinput datatypes. It should be marginally faster even for exact-matchcases, though I've not had success in proving an improvement in benchmarktests. Per report from Guillame Smet and subsequent discussion.1 parenta238bd1 commitd54ca56
File tree
3 files changed
+311
-6
lines changed- src
- backend
- catalog
- parser
- include/catalog
3 files changed
+311
-6
lines changedLines changed: 35 additions & 1 deletion
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
13 | 13 |
| |
14 | 14 |
| |
15 | 15 |
| |
16 |
| - | |
| 16 | + | |
17 | 17 |
| |
18 | 18 |
| |
19 | 19 |
| |
| |||
3006 | 3006 |
| |
3007 | 3007 |
| |
3008 | 3008 |
| |
| 3009 | + | |
| 3010 | + | |
| 3011 | + | |
| 3012 | + | |
| 3013 | + | |
| 3014 | + | |
| 3015 | + | |
| 3016 | + | |
| 3017 | + | |
| 3018 | + | |
| 3019 | + | |
| 3020 | + | |
| 3021 | + | |
| 3022 | + | |
| 3023 | + | |
| 3024 | + | |
| 3025 | + | |
| 3026 | + | |
| 3027 | + | |
| 3028 | + | |
| 3029 | + | |
| 3030 | + | |
| 3031 | + | |
| 3032 | + | |
| 3033 | + | |
| 3034 | + | |
| 3035 | + | |
| 3036 | + | |
| 3037 | + | |
| 3038 | + | |
| 3039 | + | |
| 3040 | + | |
| 3041 | + | |
| 3042 | + | |
3009 | 3043 |
| |
3010 | 3044 |
| |
3011 | 3045 |
| |
|
0 commit comments
Comments
(0)