Re: Archiver restart timer - Mailing list pgsql-patches

From Simon Riggs
Subject Re: Archiver restart timer
Date
Msg-id 1101109584.2869.86.camel@localhost.localdomain
Whole thread Raw
In response to Archiver restart timer  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Archiver restart timer
List pgsql-patches
On Sun, 2004-11-21 at 23:07, Simon Riggs wrote:
> 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.

...and now for the diff -c version.... ;-)

--
Best Regards, Simon Riggs

Attachment

pgsql-patches by date:

Previous
From: Neil Conway
Date:
Subject: Re: release.sgml refers to g_restore
Next
From: Troels Arvin
Date:
Subject: Re: SQL Conformance introductory section