I was recently running a test with multiple client shell processes running psql commands (inserts) when all the client processes appeared to hang simultaneously. I assumed that I had an application deadlock somewhere, but after a few seconds - less than a minute, but certainly noticeable - all the clients picked up again and went on their way.
In the database log at that time there was a "recycling transaction log" message which seems to correspond to the time when the clients were paused, though I don't have it concretely correlated.
I've seen these messages in the log before, and am aware of the need to increase checkpoint_segments, but I wasn't aware that recycling a transaction log could be that damaging to performance. There may have been some local hiccup in this case, but I'm wondering if recycling is known to be a big hit in general, and if I should strive to tune so that it never happens (if that's possible)?
Thanks.
- DAP
----------------------------------------------------------------------------------
David Parker Tazz Networks (401) 709-5130