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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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 Content-Type Size
pgarch.c text/x-csrc 13.9 KB

Responses

Browse pgsql-patches by date

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