Tom Lane wrote: > "Heikki Linnakangas" <[EMAIL PROTECTED]> writes: > > I just noticed that freezing a tuple (in vacuumlazy.c) is not > > WAL-logged. > > The theory is that this doesn't matter because the tuple is committed > either way ... it's equivalent to a hint-bit update which we don't > WAL-log either.
Also it'd be hugely expensive to log each freeze operation. The alternative would be to log a VACUUM FREEZE, but that has the potential to cause enormous recovery runtime. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings