Skip site navigation (1) Skip section navigation (2)

Re: Archiver restart timer

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: Re: Archiver restart timer
Date: 2004-11-22 07:46:24
Message-ID: 1101109584.2869.86.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: 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: pgarchtimer.patch
Description: text/x-patch (908 bytes)

In response to

Responses

pgsql-patches by date

Next:From: Troels ArvinDate: 2004-11-22 09:34:48
Subject: Re: SQL Conformance introductory section
Previous:From: Neil ConwayDate: 2004-11-22 07:29:41
Subject: Re: release.sgml refers to g_restore

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group