Re: What does this tell me?

> > 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.
>
> Actually, it's apparently a real problem, because the function never
> completes.  Each cycle of "recycling transaction logs" takes longer
> and longer, and eventually locks up completely.
>
> What the function is doing is a succession of data cleanup
> procedures, updating the same table about 50 times.  I will be very
> thankful for the day when I can commit within a procedure.
>
> Unfortunately, I am already at the maximum number of WAL files (64).
> What do I do now?

Isn't it possible to increase the size of your wal logs?  I seem to
remember a tunable existing, but I can't find it in the default
config.  Someone else know how off the top of their head?  -sc

--
Sean Chittenden