From: Simon Riggs <simon@2ndquadrant.com>
To: d.wall@computer.org
Cc: pgsql-admin@postgresql.org
Subject: Re: WAL copying includes vacuum, reindex, etc?
Date: Tue, 15 Jan 2008 17:35:32 +0000
Message-ID: <1200418532.4266.1767.camel@ebony.site> (raw)
In-Reply-To: <478CEB2E.4040601@computer.org>
References: <478CEB2E.4040601@computer.org>
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 maintenance items done?
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. It's probably
good for peace of mind too, but it's a long way from being an essential
requirement.
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: simon@2ndquadrant.com, d.wall@computer.org
Subject: Re: WAL copying includes vacuum, reindex, etc?
In-Reply-To: <1200418532.4266.1767.camel@ebony.site>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox