Archiver restart timer - Mailing list pgsql-patches

From Simon Riggs
Subject Archiver restart timer
Date
Msg-id 1101078421.2869.21.camel@localhost.localdomain
Whole thread Raw
Responses Re: Archiver restart timer  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-patches
I enclose a short patch to reduce the PGARCH_RESTART_INTERVAL from 60
seconds to 10 seconds. The original number was plucked from thin air
some months ago, and I'd like to review that now based upon further
thought, observation and experience.

This change has little or no effect on performance, since the interval
is there mainly to avoid repeated respawn attempts if archiver fails at
startup. Archiver start-up time is very quick, so there is little danger
of exceeding 10 seconds.

On a busy system, if the archiver does die, then many files can build up
in the 60 seconds before respawning. That xlog file backlog could take
some time to clear. This then leaves a larger than normal window of data
loss for a possibly long period.

It's a minor change only, with no other effect on function.

--
Best Regards, Simon Riggs

Attachment

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] New compile warnings
Next
From: Simon Riggs
Date:
Subject: SQL Conformance introductory section