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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
