Renato Oliveira <renato.oliveira@grant.co.uk> wrote:
> What would be a good indication for 'archive_timeout' on a busy
> server?
The maximum amount of time for which you can tolerate lost
transactions in case you need to use the backup for crash recovery.
Note that you need to balance that need against the space
requirements of the WAL files. You can mitigate the space problem
by using pg_clearxlogtail or pglesslog.
-Kevin