Re: Freezing is not WAL-logged
| От | Alvaro Herrera |
|---|---|
| Тема | Re: Freezing is not WAL-logged |
| Дата | |
| Msg-id | 20061019192204.GC16965@alvh.no-ip.org обсуждение исходный текст |
| Ответ на | Re: Freezing is not WAL-logged (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: Freezing is not WAL-logged
|
| Список | pgsql-bugs |
Tom Lane wrote: > "Heikki Linnakangas" <heikki@enterprisedb.com> 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
В списке pgsql-bugs по дате отправления: