Hello On 03/01/2008, Peter Childs <[EMAIL PROTECTED]> wrote: > Using Postgresql 8.1.10 every so often I get a transaction that takes a > while to commit. > > I log everything that takes over 500ms and quite reguallly it says things > like > > 707.036 ms statement: COMMIT > > Is there anyway to speed this up? >
there can be two issues: a) some trigger activity for DEFERRED constraints b) slow write to WAL http://www.westnet.com/~gsmith/content/postgresql/ in normal cases COMMIT is really fast operation. Regards Pavel Stehule > Peter Childs > > > > ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
