forked frompostgres/postgres
- Notifications
You must be signed in to change notification settings - Fork6
Commitdbab0c0
committed
Remove forced toast recompression in VACUUM FULL/CLUSTER
The extra checks added by the recompression of toast data introduced inbbe0a81 is proving to have a performance impact on VACUUM or CLUSTEReven if no recompression is done. This is more noticeable with moretoastable columns that contain non-NULL values.Improvements could be done to make those extra checks less expensive,but that's not material for 14 at this stage, and we are not sure eitherif the code path of VACUUM FULL/CLUSTER is adapted for this job.Per discussion with several people, including Andres Freund, RobertHaas, Álvaro Herrera, Tom Lane and myself.Discussion:https://postgr.es/m/20210527003144.xxqppojoiwurc2iz@alap3.anarazel.de1 parentf807e34 commitdbab0c0
File tree
5 files changed
+6
-66
lines changed- doc/src/sgml/ref
- src
- backend/access/heap
- test/regress
- expected
- sql
5 files changed
+6
-66
lines changedLines changed: 1 addition & 2 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
394 | 394 |
| |
395 | 395 |
| |
396 | 396 |
| |
397 |
| - | |
398 |
| - | |
| 397 | + | |
399 | 398 |
| |
400 | 399 |
| |
401 | 400 |
| |
|
Lines changed: 1 addition & 60 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
19 | 19 |
| |
20 | 20 |
| |
21 | 21 |
| |
22 |
| - | |
23 | 22 |
| |
24 | 23 |
| |
25 | 24 |
| |
26 | 25 |
| |
27 | 26 |
| |
28 | 27 |
| |
29 | 28 |
| |
30 |
| - | |
31 | 29 |
| |
32 | 30 |
| |
33 | 31 |
| |
| |||
2463 | 2461 |
| |
2464 | 2462 |
| |
2465 | 2463 |
| |
2466 |
| - | |
2467 |
| - | |
2468 |
| - | |
2469 | 2464 |
| |
2470 | 2465 |
| |
2471 | 2466 |
| |
| 2467 | + | |
2472 | 2468 |
| |
2473 | 2469 |
| |
2474 |
| - | |
2475 | 2470 |
| |
2476 | 2471 |
| |
2477 |
| - | |
2478 |
| - | |
2479 |
| - | |
2480 |
| - | |
2481 |
| - | |
2482 |
| - | |
2483 |
| - | |
2484 |
| - | |
2485 |
| - | |
2486 |
| - | |
2487 |
| - | |
2488 |
| - | |
2489 |
| - | |
2490 |
| - | |
2491 |
| - | |
2492 |
| - | |
2493 |
| - | |
2494 |
| - | |
2495 |
| - | |
2496 |
| - | |
2497 |
| - | |
2498 |
| - | |
2499 |
| - | |
2500 |
| - | |
2501 |
| - | |
2502 |
| - | |
2503 |
| - | |
2504 |
| - | |
2505 |
| - | |
2506 |
| - | |
2507 |
| - | |
2508 |
| - | |
2509 |
| - | |
2510 |
| - | |
2511 |
| - | |
2512 |
| - | |
2513 |
| - | |
2514 |
| - | |
2515 |
| - | |
2516 |
| - | |
2517 |
| - | |
2518 |
| - | |
2519 |
| - | |
2520 |
| - | |
2521 |
| - | |
2522 |
| - | |
2523 |
| - | |
2524 | 2472 |
| |
2525 | 2473 |
| |
2526 | 2474 |
| |
2527 | 2475 |
| |
2528 | 2476 |
| |
2529 | 2477 |
| |
2530 | 2478 |
| |
2531 |
| - | |
2532 |
| - | |
2533 |
| - | |
2534 |
| - | |
2535 |
| - | |
2536 |
| - | |
2537 |
| - | |
2538 | 2479 |
| |
2539 | 2480 |
| |
2540 | 2481 |
| |
|
Lines changed: 2 additions & 2 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
297 | 297 |
| |
298 | 298 |
| |
299 | 299 |
| |
300 |
| - | |
| 300 | + | |
301 | 301 |
| |
302 | 302 |
| |
303 | 303 |
| |
| |||
309 | 309 |
| |
310 | 310 |
| |
311 | 311 |
| |
312 |
| - | |
| 312 | + | |
313 | 313 |
| |
314 | 314 |
| |
315 | 315 |
| |
|
Lines changed: 1 addition & 1 deletion
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
293 | 293 |
| |
294 | 294 |
| |
295 | 295 |
| |
296 |
| - | |
| 296 | + | |
297 | 297 |
| |
298 | 298 |
| |
299 | 299 |
| |
|
Lines changed: 1 addition & 1 deletion
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
126 | 126 |
| |
127 | 127 |
| |
128 | 128 |
| |
129 |
| - | |
| 129 | + | |
130 | 130 |
| |
131 | 131 |
| |
132 | 132 |
| |
|
0 commit comments
Comments
(0)