Thread: pgsql: > I enclose a short patch to reduce the PGARCH_RESTART_INTERVAL
pgsql: > I enclose a short patch to reduce the PGARCH_RESTART_INTERVAL
From
momjian@svr1.postgresql.org (Bruce Momjian)
Date:
Log Message: ----------- > 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. Simon Riggs Modified Files: -------------- pgsql/src/backend/postmaster: pgarch.c (r1.12 -> r1.13) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/postmaster/pgarch.c.diff?r1=1.12&r2=1.13)