> I would like to see some checking of this, though. Currently > I'm doing testing of PostgreSQL under very large numbers of > connections (2000+) and am finding that there's a huge volume > of xlog output ... far more than > comparable RDBMSes. So I think we are logging stuff we > don't really have to.
I think you really have to lengthen the checkpoint interval to reduce WAL overhead (20 min or so). Also imho you cannot only compare the log size/activity since other db's write part of what pg writes to WAL to other areas (physical log, rollback segment, ...). If we cannot afford lenghtening the checkpoint interval because of too heavy checkpoint load, we need to find ways to tune bgwriter, and not reduce checkpoint interval. Andreas ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
