Re: [GENERAL] Truncate and delete adds wal logs for slave to process.

2010-02-11 Thread Alvaro Herrera
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 th

Re: [GENERAL] Truncate and delete adds wal logs for slave to process.

2010-02-11 Thread Greg Stark
On Thu, Feb 11, 2010 at 5:47 PM, 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? > > To reduce this logging, ship