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

Reply via email to