On Mon, 9 Apr 2007, Bruce Momjian wrote:
The big question is who is going to care about the milliseconds delay and is using a configuration that is going to benefit from commit_delay.
I care. WAL writes are a major bottleneck when many clients are committing near the same time. Both times I've played with the commit_delay settings I found it improved the peak throughput under load at an acceptable low cost in latency. I'll try to present some numbers on that when I get time, before you make me cry by taking it away.
An alternate mechanism that tells the client the commit is done when it hasn't hit disk is of no use for the applications I work with, so I haven't even been paying attention to no-commit-wait.
-- * Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
