Commit takes a long time.

From: "Peter Childs" <peterachilds(at)gmail(dot)com>
To: "Postgresql Performance" <pgsql-performance(at)postgresql(dot)org>
Subject: Commit takes a long time.
Date: 2008-01-03 14:35:37
Message-ID: a2de01dd0801030635v3491f576oabd4b3bb58d8328b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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?

Peter Childs

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Pavel Stehule 2008-01-03 16:20:01 Re: Commit takes a long time.
Previous Message Jakub Ouhrabka 2008-01-03 11:50:01 Linux/PostgreSQL scalability issue - problem with 8 cores