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