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

pgsql: > I enclose a short patch to reduce the PGARCH_RESTART_INTERVAL

From: momjian(at)svr1(dot)postgresql(dot)org (Bruce Momjian)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: > I enclose a short patch to reduce the PGARCH_RESTART_INTERVAL
Date: 2004-12-02 22:40:21
Message-ID: 20041202224021.08C8C3A599F@svr1.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
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)

pgsql-committers by date

Next:From: Bruce MomjianDate: 2004-12-02 22:48:14
Subject: pgsql: > > 8.0beta3 has pg_autovacuum included, when I want to run this
Previous:From: Bruce MomjianDate: 2004-12-02 22:37:15
Subject: pgsql: Fix for Unicode characters above 0x10000.

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