Log message: "recycled transaction log file..."

[Bill Chandler]

Hello,

Sorry if this is a too basic or is a FAQ. I've done
some research but it's still unclear if this is
something I should be concerned about.

Running PostgreSQL 7.4.2 on Solaris 8. I'm getting a
lot of the following messages in my log file:

LOG: recycled transaction log file "0000000200000003E"

I realize this has something to do with checkpoints
and the WAL. I'm just not clear on if this is
something I should be concerned about or not. Could
somebody explain in layman's terms what is going on
here? Do I need tofix something? Is this a
performance issue?

thanks in advance,

Bill



__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Tom Lane]

Post by Bill Chandler
Running PostgreSQL 7.4.2 on Solaris 8. I'm getting a
LOG: recycled transaction log file "0000000200000003E"

This is normal behavior. At some point we'll probably knock down the
priority of those messages from LOG to DEBUG ...

regards, tom lane

---------------------------(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