Re: Visibility map, partial vacuums

Heikki Linnakangas wrote:
> >> Also, is anything being done about the concern about 'vacuum storm'
> >> explained below?
> >
> > I'm interested too.
>
> The additional "vacuum_freeze_table_age" (as I'm now calling it) setting
> I discussed in a later thread should alleviate that somewhat. When a
> table is autovacuumed, the whole table is scanned to freeze tuples if
> it's older than vacuum_freeze_table_age, and relfrozenxid is advanced.
> When different tables reach the autovacuum threshold at different times,
> they will also have their relfrozenxids set to different values. And in
> fact no anti-wraparound vacuum is needed.
>
> That doesn't help with read-only or insert-only tables, but that's not a
> new problem.

OK, is this targeted for 8.4?

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +