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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073