Bruce, Sean,
> 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?
-Josh Berkus