Re: Truncate and delete adds wal logs for slave to process.
От
Alvaro Herrera
Тема
Re: Truncate and delete adds wal logs for slave to
process.
Дата
Msg-id
20100211233013.GK3145@alvh.no-ip.org
Ответ на
Truncate and delete adds wal logs for slave to process. (Chris Barnes)
Список
Дерево обсуждения
Truncate and delete adds wal logs for slave to process. Chris Barnes <compuguruchrisbarnes@hotmail.com>
Re: Truncate and delete adds wal logs for slave to
process. Alvaro Herrera <alvherre@commandprompt.com>
Re: Truncate and delete adds wal logs for slave to process. Greg Stark <gsstark@mit.edu>
Chris Barnes wrote: > Because both truncate and delete, I would think that this action would > be put into the pg_log as a log file that can be rolled back. And, > when complete, it would be shipped to the standby to be processed? You would be wrong -- truncate does not log the full data, only the fact that a truncate happened. In order to be able to roll it back, the underlying file is kept around until transaction commit. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
В списке pgsql-general по дате отправления
От: Francisco Reyes
Дата: