forked frompostgres/postgres
- Notifications
You must be signed in to change notification settings - Fork6
Commit41a033b
committed
Preserve index data in pg_statistic across REINDEX CONCURRENTLY
Statistics associated to an index got lost after running REINDEXCONCURRENTLY, while the non-concurrent case preserves these correctly.The concurrent and non-concurrent operations need to be consistent forthe end-user, and missing statistics would force to wait for a newanalyze to happen, which could take some time depending on the activityof the existing autovacuum workers. This issue is fixed by copying anyexisting entries in pg_statistic associated to the old index to the newone. Note that this copy is already done with the data of the index inthe stats collector.Reported-by: Fabrízio de Royes MelloAuthor: Michael Paquier, Fabrízio de Royes MelloReviewed-by: Justin PryzbyDiscussion:https://postgr.es/m/CAFcNs+qpFPmiHd1oTXvcPdvAHicJDA9qBUSujgAhUMJyUMb+SA@mail.gmail.comBackpatch-through: 121 parent741b84e commit41a033b
File tree
5 files changed
+79
-0
lines changed- src
- backend/catalog
- include/catalog
- test/regress
- expected
- sql
5 files changed
+79
-0
lines changedLines changed: 41 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
3113 | 3113 |
| |
3114 | 3114 |
| |
3115 | 3115 |
| |
| 3116 | + | |
| 3117 | + | |
| 3118 | + | |
| 3119 | + | |
| 3120 | + | |
| 3121 | + | |
| 3122 | + | |
| 3123 | + | |
| 3124 | + | |
| 3125 | + | |
| 3126 | + | |
| 3127 | + | |
| 3128 | + | |
| 3129 | + | |
| 3130 | + | |
| 3131 | + | |
| 3132 | + | |
| 3133 | + | |
| 3134 | + | |
| 3135 | + | |
| 3136 | + | |
| 3137 | + | |
| 3138 | + | |
| 3139 | + | |
| 3140 | + | |
| 3141 | + | |
| 3142 | + | |
| 3143 | + | |
| 3144 | + | |
| 3145 | + | |
| 3146 | + | |
| 3147 | + | |
| 3148 | + | |
| 3149 | + | |
| 3150 | + | |
| 3151 | + | |
| 3152 | + | |
| 3153 | + | |
| 3154 | + | |
| 3155 | + | |
| 3156 | + | |
3116 | 3157 |
| |
3117 | 3158 |
| |
3118 | 3159 |
| |
|
Lines changed: 3 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
1714 | 1714 |
| |
1715 | 1715 |
| |
1716 | 1716 |
| |
| 1717 | + | |
| 1718 | + | |
| 1719 | + | |
1717 | 1720 |
| |
1718 | 1721 |
| |
1719 | 1722 |
| |
|
Lines changed: 1 addition & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
132 | 132 |
| |
133 | 133 |
| |
134 | 134 |
| |
| 135 | + | |
135 | 136 |
| |
136 | 137 |
| |
137 | 138 |
| |
|
Lines changed: 22 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
2406 | 2406 |
| |
2407 | 2407 |
| |
2408 | 2408 |
| |
| 2409 | + | |
| 2410 | + | |
| 2411 | + | |
| 2412 | + | |
| 2413 | + | |
| 2414 | + | |
| 2415 | + | |
| 2416 | + | |
| 2417 | + | |
| 2418 | + | |
| 2419 | + | |
2409 | 2420 |
| |
2410 | 2421 |
| |
2411 | 2422 |
| |
| |||
2463 | 2474 |
| |
2464 | 2475 |
| |
2465 | 2476 |
| |
| 2477 | + | |
| 2478 | + | |
| 2479 | + | |
| 2480 | + | |
| 2481 | + | |
| 2482 | + | |
| 2483 | + | |
| 2484 | + | |
| 2485 | + | |
| 2486 | + | |
| 2487 | + | |
2466 | 2488 |
| |
2467 | 2489 |
| |
2468 | 2490 |
| |
|
Lines changed: 12 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
997 | 997 |
| |
998 | 998 |
| |
999 | 999 |
| |
| 1000 | + | |
| 1001 | + | |
| 1002 | + | |
| 1003 | + | |
| 1004 | + | |
| 1005 | + | |
1000 | 1006 |
| |
1001 | 1007 |
| |
1002 | 1008 |
| |
| |||
1009 | 1015 |
| |
1010 | 1016 |
| |
1011 | 1017 |
| |
| 1018 | + | |
| 1019 | + | |
| 1020 | + | |
| 1021 | + | |
| 1022 | + | |
| 1023 | + | |
1012 | 1024 |
| |
1013 | 1025 |
| |
1014 | 1026 |
| |
|
0 commit comments
Comments
(0)