Postgres Pro
Downloads
Home   >   mailing lists

Commit takes a long time. - Mailing list pgsql-performance

From Peter Childs
Subject Commit takes a long time.
Date
Msg-id a2de01dd0801030635v3491f576oabd4b3bb58d8328b@mail.gmail.com
Whole thread Raw
Responses Re: Commit takes a long time.  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Re: Commit takes a long time.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view
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



pgsql-performance by date:

Previous
From: Jakub Ouhrabka
Date:
Subject: Linux/PostgreSQL scalability issue - problem with 8 cores
Next
From: "Pavel Stehule"
Date:
Subject: Re: Commit takes a long time.