Commit takes a long time.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Postgresql Performance" <pgsql-performance@xxxxxxxxxxxxxx>
Subject: Commit takes a long time.
From: "Peter Childs" <peterachilds@xxxxxxxxx>
Date: Thu, 3 Jan 2008 14:35:37 +0000

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

Follow-Ups:
- Re: Commit takes a long time.
  - From: Tom Lane
- Re: Commit takes a long time.
  - From: Pavel Stehule

Prev by Date: Linux/PostgreSQL scalability issue - problem with 8 cores
Next by Date: Re: Commit takes a long time.
Previous by thread: Linux/PostgreSQL scalability issue - problem with 8 cores
Next by thread: Re: Commit takes a long time.
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux