]> granicus.if.org Git - postgresql/commit
Update relation's stats in pg_class during vacuum full.
authorTeodor Sigaev <teodor@sigaev.ru>
Wed, 27 Dec 2017 15:25:37 +0000 (18:25 +0300)
committerTeodor Sigaev <teodor@sigaev.ru>
Wed, 27 Dec 2017 15:25:37 +0000 (18:25 +0300)
commitad337c76b6f454157982309089c3302fe77c9cbc
treee1b6471209b522f97836d0d5f51b282ccfbf3052
parenta2c8e5cfdb9d82ae6d4bb8f37a4dc7cbeca63ec1
Update relation's stats in pg_class during vacuum full.

Hash index depends on estimation of numbers of tuples and pages of relations,
incorrect value could be a reason of significantly growing of index. Vacuum
full recreates heap and reindex all indexes before renewal stats. The patch
fixes that, so indexes will see correct values.

Backpatch to v10 only because earlier versions haven't usable hash index and
growing of hash index is a single user-visible symptom.

Author: Amit Kapila
Reviewed-by: Ashutosh Sharma, me
Discussion: https://www.postgresql.org/message-id/flat/20171115232922.5tomkxnw3iq6jsg7@inml.weebeastie.net
src/backend/commands/cluster.c