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

Archiver restart timer

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: Archiver restart timer
Date: 2004-11-21 23:07:01
Message-ID: 1101078421.2869.21.camel@localhost.localdomain (view raw, whole thread or download thread mbox)
Lists: 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: pgarch.c
Description: text/x-csrc (13.9 KB)


pgsql-patches by date

Next:From: Simon RiggsDate: 2004-11-21 23:37:50
Subject: SQL Conformance introductory section
Previous:From: Tom LaneDate: 2004-11-21 22:14:39
Subject: Re: New compile warnings

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