diff options
| author | Michael Paquier <michael@paquier.xyz> | 2020-11-01 21:24:10 +0900 |
|---|---|---|
| committer | Michael Paquier <michael@paquier.xyz> | 2020-11-01 21:24:10 +0900 |
| commit | bb62df46bcaa109d5eb1907392034024dde0886e (patch) | |
| tree | 999300ca6a091e06ee2f6bf0c6ba9cb4b61c11b3 /src/backend/executor | |
| parent | ab2e2ce466683b6af5ec956106cd905380d3d349 (diff) | |
| download | postgresql-bb62df46bcaa109d5eb1907392034024dde0886e.tar.gz postgresql-bb62df46bcaa109d5eb1907392034024dde0886e.zip | |
Preserve index data in pg_statistic across REINDEX CONCURRENTLY
Statistics associated to an index got lost after running REINDEX
CONCURRENTLY, while the non-concurrent case preserves these correctly.
The concurrent and non-concurrent operations need to be consistent for
the end-user, and missing statistics would force to wait for a new
analyze to happen, which could take some time depending on the activity
of the existing autovacuum workers. This issue is fixed by copying any
existing entries in pg_statistic associated to the old index to the new
one. Note that this copy is already done with the data of the index in
the stats collector.
Reported-by: FabrÃzio de Royes Mello
Author: Michael Paquier, FabrÃzio de Royes Mello
Reviewed-by: Justin Pryzby
Discussion: https://postgr.es/m/CAFcNs+qpFPmiHd1oTXvcPdvAHicJDA9qBUSujgAhUMJyUMb+SA@mail.gmail.com
Backpatch-through: 12
Diffstat (limited to 'src/backend/executor')
0 files changed, 0 insertions, 0 deletions