Re: What does this tell me?

Sean Chittenden wrote:
> > 2002-10-08 20:37:13 DEBUG:  recycled transaction log file
> > 0000000A000000E4
> > 2002-10-08 20:37:13 DEBUG:  recycled transaction log file
> > 0000000A000000E5
> > 2002-10-08 20:37:13 DEBUG:  recycled transaction log file
> > 0000000A000000E6
> > 2002-10-08 20:37:13 DEBUG:  recycled transaction log file
> > 0000000A000000E7
> > 2002-10-08 20:37:13 DEBUG:  recycled transaction log file
> > 0000000A000000E8
> > 2002-10-08 20:37:13 DEBUG:  recycled transaction log file
> > 0000000A000000E9
> > 2002-10-08 20:37:13 DEBUG:  recycled transaction log file
> > 0000000A000000EA
> > 2002-10-08 20:37:13 DEBUG:  recycled transaction log file
> > 0000000A000000EB
> > 2002-10-08 20:37:13 DEBUG:  recycled transaction log file
> > 0000000A000000EC
> > 2002-10-08 20:37:13 DEBUG:  recycled transaction log file
> > 0000000A000000ED
> > 2002-10-08 20:37:13 DEBUG:  recycled transaction log file
> > 0000000A000000EE
> > 2002-10-08 20:37:13 DEBUG:  recycled transaction log file
> > 0000000A000000EF
> > 2002-10-08 20:37:13 DEBUG:  reaping dead processes
> > 2002-10-08 20:37:13 DEBUG:  child process (pid 15270) exited with exit
> > code 0
> >
> > ... repeat ad nauseum.  The problem is, each "recycle transaction
> > log ... reaping dead child process" cycle takes about 4-7 minutes
> > ...  meaning that the procedure can take up to 1/2 hour to finish,
> > and sometimes not finish at all.
> >
> > Obviously, the system is telling me that it is running out of
> > resources somehow.  But I'm at my wit's end to figure out what
> > resources, exactly.  Suggestions?
>
> You're running out of WAL log space, iirc.  Increase the number of WAL
> logs available and you should be okay.  If you're experiencing this
> halfway through, I'd increase the size by 50%, say maybe 60-70% for
> good measure.  -sc

Oh, yes, you are right.  My hardware tuning guide mentions it.  Strange
it is called the transaction log file:

    http://www.ca.postgresql.org/docs/momjian/hw_performance/

Unless you are seeing this more freqently than every minute, it should
be fine.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073