Commit71b6617

committed

CREATE INDEX: do not update stats during binary upgrade.

During binary upgrade, indexes are created before the data is movedinto place, so it will always be zero.This is not currently a major problem, but will be when we try topreserve statistics during upgrade.Author: Corey HuinkerDiscussion:https://postgr.es/m/CADkLM=daPdFB8V0tgFxK-dLowFsAEzWRWJHyxij7BG3kBjcouA@mail.gmail.com

1 parent0628670 commit71b6617Copy full SHA for 71b6617

File tree

-1

lines changed

-1

lines changed

Lines changed: 5 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -2874,7 +2874,11 @@ index_update_stats(Relation rel,`
`2874`	`2874`	`dirty= true;`
`2875`	`2875`	`}`
`2876`	`2876`
`2877`		`-if (reltuples >=0)`
	`2877`	`+/*`
	`2878`	`+ * Avoid updating statistics during binary upgrade, because the indexes`
	`2879`	`+ * are created before the data is moved into place.`
	`2880`	`+ */`
	`2881`	`+if (reltuples >=0&& !IsBinaryUpgrade)`
`2878`	`2882`	`{`
`2879`	`2883`	`BlockNumberrelpages=RelationGetNumberOfBlocks(rel);`
`2880`	`2884`	`BlockNumberrelallvisible;`

Comments

(0)