When running WAL backups and warm-standby restores (we're currently on
PG 8.2), do the vacuumlo changes, vacuum, analyze and reindex type
commands get pushed through WAL files to the backup? Or will the backup
database not have these maintenance items done?
Thanks,
David
On Tue, 2008-01-15 at 09:19 -0800, David Wall wrote:
When running WAL backups and warm-standby restores (we're currently on
PG 8.2), do the vacuumlo changes, vacuum, analyze and reindex type
commands get pushed through WAL files to the backup? Or will the backup
database not have these
Simon Riggs [EMAIL PROTECTED] writes:
All of those commands produce WAL for critical changes to data blocks,
so those are passed through correctly.
Hint bits are not set following recovery, so a full database VACUUM may
help later performance, depends upon your access patterns.
That's only