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 <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
Дата:
От: David Kerr
Дата:
Сообщение: Re: Deadlock Detected
FAQ