Received: from localhost (unknown [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id C1EFB2E305F
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu,  3 Jan 2008 10:35:42 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024)
	with ESMTP id 67817-01 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Thu,  3 Jan 2008 10:35:34 -0400 (AST)
Received: from nf-out-0910.google.com (nf-out-0910.google.com
 [64.233.182.185])
	by postgresql.org (Postfix) with ESMTP id 919C32E2F66
	for <pgsql-performance@postgresql.org>;
	Thu,  3 Jan 2008 10:35:39 -0400 (AST)
Received: by nf-out-0910.google.com with SMTP id f5so374404nfh.23
	for <pgsql-performance@postgresql.org>;
	Thu, 03 Jan 2008 06:35:37 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type;
	bh=1ymu/0Ip9nEAYkJsgT7qiYbTRFYDWq3KOOFZgz2oDAA=;
	b=PDvkg3+rCe46wuznSseTXQWJwLWvEfvq6Z2oK9bFCQU+KwmlWytt9Ea/UFBLhzbrYggIAPdBFXvLU9vwCJtBhzP5LFUMCPBv/ym4DTiDy8oxlqZQ+TeTu9CRMviSG7xj2db4BUh343nhMr/Mglts8ugrQh0T0VQiOFg0u+mpe7k=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type;
	b=TCwWrC8E4pn+z2YZgczBjOXM2OmtpIWwZ2fHNGh3wsd5eL/n+qkfkO/ORZatH5Z4TXAYMCaEYA6lOglwj+b39LQoN8Mp1SO1sHSIDbbBmbUBdFzq9DY01A8tcoQmF+5DgAv/r9ZVE4Hm5fkqC710g0ystUKRd5uSWSAZPTdpo/o=
Received: by 10.78.172.20 with SMTP id u20mr18121240hue.13.1199370937329;
	Thu, 03 Jan 2008 06:35:37 -0800 (PST)
Received: by 10.78.150.15 with HTTP; Thu, 3 Jan 2008 06:35:37 -0800 (PST)
Message-ID: <a2de01dd0801030635v3491f576oabd4b3bb58d8328b@mail.gmail.com>
Date: Thu, 3 Jan 2008 14:35:37 +0000
From: "Peter Childs" <peterachilds@gmail.com>
To: "Postgresql Performance" <pgsql-performance@postgresql.org>
Subject: Commit takes a long time.
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_25877_21494480.1199370937326"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200801/3
X-Sequence-Number: 28242

------=_Part_25877_21494480.1199370937326
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_25877_21494480.1199370937326
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Using Postgresql 8.1.10 every so often I get a transaction that takes a while to commit.<br><br>I log everything that takes over 500ms and quite reguallly it says things like<br><br>707.036 ms statement: COMMIT<br><br>Is there anyway to speed this up?
<br><br>Peter Childs<br><br><br><br>

------=_Part_25877_21494480.1199370937326--