forked frompostgres/postgres
- Notifications
You must be signed in to change notification settings - Fork6
Commit8a6ac83
committed
Fix some planner performance problems with large WHERE clauses, by
introducing new 'FastList' list-construction subroutines to use inhot spots. This avoids the O(N^2) behavior of repeated lappend'sby keeping a tail pointer, while not changing behavior by reversinglist order as the lcons() method would do.1 parent0f3c68a commit8a6ac83
File tree
8 files changed
+364
-192
lines changed- src
- backend
- executor
- nodes
- optimizer
- path
- prep
- util
- include/nodes
8 files changed
+364
-192
lines changedLines changed: 19 additions & 15 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
8 | 8 |
| |
9 | 9 |
| |
10 | 10 |
| |
11 |
| - | |
| 11 | + | |
12 | 12 |
| |
13 | 13 |
| |
14 | 14 |
| |
| |||
2320 | 2320 |
| |
2321 | 2321 |
| |
2322 | 2322 |
| |
2323 |
| - | |
| 2323 | + | |
2324 | 2324 |
| |
2325 | 2325 |
| |
| 2326 | + | |
2326 | 2327 |
| |
2327 | 2328 |
| |
2328 | 2329 |
| |
| |||
2332 | 2333 |
| |
2333 | 2334 |
| |
2334 | 2335 |
| |
2335 |
| - | |
| 2336 | + | |
2336 | 2337 |
| |
2337 |
| - | |
| 2338 | + | |
2338 | 2339 |
| |
2339 | 2340 |
| |
2340 | 2341 |
| |
| |||
2345 | 2346 |
| |
2346 | 2347 |
| |
2347 | 2348 |
| |
2348 |
| - | |
| 2349 | + | |
2349 | 2350 |
| |
2350 | 2351 |
| |
| 2352 | + | |
2351 | 2353 |
| |
2352 | 2354 |
| |
2353 | 2355 |
| |
2354 | 2356 |
| |
2355 | 2357 |
| |
2356 | 2358 |
| |
2357 |
| - | |
| 2359 | + | |
2358 | 2360 |
| |
2359 |
| - | |
| 2361 | + | |
2360 | 2362 |
| |
2361 | 2363 |
| |
2362 | 2364 |
| |
| |||
2369 | 2371 |
| |
2370 | 2372 |
| |
2371 | 2373 |
| |
2372 |
| - | |
| 2374 | + | |
2373 | 2375 |
| |
2374 | 2376 |
| |
| 2377 | + | |
2375 | 2378 |
| |
2376 | 2379 |
| |
2377 | 2380 |
| |
2378 | 2381 |
| |
2379 | 2382 |
| |
2380 | 2383 |
| |
2381 |
| - | |
| 2384 | + | |
2382 | 2385 |
| |
2383 |
| - | |
| 2386 | + | |
2384 | 2387 |
| |
2385 | 2388 |
| |
2386 | 2389 |
| |
| |||
2434 | 2437 |
| |
2435 | 2438 |
| |
2436 | 2439 |
| |
2437 |
| - | |
| 2440 | + | |
2438 | 2441 |
| |
2439 | 2442 |
| |
| 2443 | + | |
2440 | 2444 |
| |
2441 | 2445 |
| |
2442 |
| - | |
2443 |
| - | |
2444 |
| - | |
| 2446 | + | |
| 2447 | + | |
| 2448 | + | |
2445 | 2449 |
| |
2446 | 2450 |
| |
2447 |
| - | |
| 2451 | + | |
2448 | 2452 |
| |
2449 | 2453 |
| |
2450 | 2454 |
| |
|
Lines changed: 117 additions & 3 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
9 | 9 |
| |
10 | 10 |
| |
11 | 11 |
| |
12 |
| - | |
| 12 | + | |
13 | 13 |
| |
14 | 14 |
| |
15 | 15 |
| |
| |||
141 | 141 |
| |
142 | 142 |
| |
143 | 143 |
| |
144 |
| - | |
| 144 | + | |
145 | 145 |
| |
146 |
| - | |
| 146 | + | |
147 | 147 |
| |
148 | 148 |
| |
149 | 149 |
| |
| |||
195 | 195 |
| |
196 | 196 |
| |
197 | 197 |
| |
| 198 | + | |
| 199 | + | |
| 200 | + | |
| 201 | + | |
| 202 | + | |
| 203 | + | |
| 204 | + | |
| 205 | + | |
| 206 | + | |
| 207 | + | |
| 208 | + | |
| 209 | + | |
| 210 | + | |
| 211 | + | |
| 212 | + | |
| 213 | + | |
| 214 | + | |
| 215 | + | |
| 216 | + | |
| 217 | + | |
| 218 | + | |
| 219 | + | |
| 220 | + | |
| 221 | + | |
| 222 | + | |
| 223 | + | |
| 224 | + | |
| 225 | + | |
| 226 | + | |
| 227 | + | |
| 228 | + | |
| 229 | + | |
| 230 | + | |
| 231 | + | |
| 232 | + | |
| 233 | + | |
| 234 | + | |
| 235 | + | |
| 236 | + | |
| 237 | + | |
| 238 | + | |
| 239 | + | |
| 240 | + | |
| 241 | + | |
| 242 | + | |
| 243 | + | |
| 244 | + | |
| 245 | + | |
| 246 | + | |
| 247 | + | |
| 248 | + | |
| 249 | + | |
| 250 | + | |
| 251 | + | |
| 252 | + | |
| 253 | + | |
| 254 | + | |
| 255 | + | |
| 256 | + | |
| 257 | + | |
| 258 | + | |
| 259 | + | |
| 260 | + | |
| 261 | + | |
| 262 | + | |
| 263 | + | |
| 264 | + | |
| 265 | + | |
| 266 | + | |
| 267 | + | |
| 268 | + | |
| 269 | + | |
| 270 | + | |
| 271 | + | |
| 272 | + | |
| 273 | + | |
| 274 | + | |
| 275 | + | |
| 276 | + | |
| 277 | + | |
| 278 | + | |
| 279 | + | |
| 280 | + | |
| 281 | + | |
| 282 | + | |
| 283 | + | |
| 284 | + | |
| 285 | + | |
| 286 | + | |
| 287 | + | |
| 288 | + | |
| 289 | + | |
| 290 | + | |
| 291 | + | |
| 292 | + | |
| 293 | + | |
| 294 | + | |
| 295 | + | |
| 296 | + | |
| 297 | + | |
| 298 | + | |
| 299 | + | |
| 300 | + | |
| 301 | + | |
| 302 | + | |
| 303 | + | |
| 304 | + | |
| 305 | + | |
| 306 | + | |
| 307 | + | |
| 308 | + | |
| 309 | + | |
| 310 | + | |
| 311 | + | |
198 | 312 |
| |
199 | 313 |
| |
200 | 314 |
| |
|
0 commit comments
Comments
(0)