NotificationsYou must be signed in to change notification settings
Fork5
Star26

Commitdd1569d

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 parent9ee00ef commitdd1569dCopy full SHA for dd1569d

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
`@@ -449,7 +449,7 @@ vacuum_set_xid_limits(int freeze_min_age,`
`449`	`449`	`* VACUUM schedule, the nightly VACUUM gets a chance to freeze tuples`
`450`	`450`	`* before anti-wraparound autovacuum is launched.`
`451`	`451`	`*/`
`452`		`-freezetable=freeze_min_age;`
	`452`	`+freezetable=freeze_table_age;`
`453`	`453`	`if (freezetable<0)`
`454`	`454`	`freezetable=vacuum_freeze_table_age;`
`455`	`455`	`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!

Commitdd1569d

File tree

1 file changed

1 file changed

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

0 commit comments