NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit231dbb3

committed

Fix typo in freeze_table_age implementation

The original code used freeze_min_age instead of freeze_table_age. Themain consequence of this mistake is that lowering freeze_min_age wouldcause full-table scans to occur much more frequently, which causesserious issues because the number of writes required is much larger.That feature (freeze_min_age) is supposed to affect only how soon tuplesare frozen; some pages should still be skipped due to the visibilitymap.Backpatch to 8.4, where the freeze_table_age feature was introduced.Report and patch from Andres Freund

1 parent1a7cd9f commit231dbb3Copy full SHA for 231dbb3

File tree

1 file changed

-1

lines changed

src/backend/commands
- vacuum.c

1 file changed

-1

lines changed

`‎src/backend/commands/vacuum.c`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -446,7 +446,7 @@ vacuum_set_xid_limits(int freeze_min_age,`
`446`	`446`	`* VACUUM schedule, the nightly VACUUM gets a chance to freeze tuples`
`447`	`447`	`* before anti-wraparound autovacuum is launched.`
`448`	`448`	`*/`
`449`		`-freezetable=freeze_min_age;`
	`449`	`+freezetable=freeze_table_age;`
`450`	`450`	`if (freezetable<0)`
`451`	`451`	`freezetable=vacuum_freeze_table_age;`
`452`	`452`	`freezetable=Min(freezetable,autovacuum_freeze_max_age*0.95);`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit231dbb3

File tree

1 file changed

1 file changed

`‎src/backend/commands/vacuum.c`

0 commit comments