Patch applied. Thanks. ---------------------------------------------------------------------------
Simon Riggs wrote: > 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, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
