Heikki Linnakangas <[EMAIL PROTECTED]> writes: > Maybe we can do something to reduce the xid consumption? For example, > reuse xids for read-only queries.
Hmm, that's an idea. More simply, just keep the current transaction open (resetting everything but the XID) if we have made no changes by the time we're told to commit or rollback ... which is something we track already, so as not to waste cycles on useless commit XLOG records. You'd want some upper limit on transaction lifetime, so as to avoid the "long lived transactions hurt VACUUM" problem, but even reusing a single xact for a few seconds would pretty much eliminate this issue, I bet. It's hard to see how anyone could be doing 6K xacts/sec unless most are read-only. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings