Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 5A7692E392A for ; Thu, 3 Jan 2008 12:20:08 -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 25265-01 for ; Thu, 3 Jan 2008 12:20:03 -0400 (AST) Received: from mu-out-0910.google.com (mu-out-0910.google.com [209.85.134.190]) by postgresql.org (Postfix) with ESMTP id 7FCB72E388B for ; Thu, 3 Jan 2008 12:20:03 -0400 (AST) Received: by mu-out-0910.google.com with SMTP id i10so4761724mue.5 for ; Thu, 03 Jan 2008 08:20:02 -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:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=97JNuAvsRM9PYUpgZcPmMuv444kI+AZE/v4ITJzVx74=; b=L9pXeFfvILhZHulY9q8HA3BVcZFZcp8ahOW+H2D1lHjz2VlWdKO5OtEdacAHanyZfjIqAa5Gq4FnVyzy6c++A4lrS2RBD8j0yzmi+Vmqu1KkUd/CUILSLExIUFmzERKzGxChQMz3Ofl4xBWfsi/nT27xyAnIVpLsHBEh7Bci0ww= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=PHRRuLfwzw1n0LjRkW3HfFiHknVSsmpRYtHosBoij5pUJHO5f174HJgW429OUb/61dwym0NB2P/FjwyQTMKY3HLUGSWZarAyhj8YCN3Fj64LHgwTf3CuGCrPOYHC/m7jyH6wMRqgqg2jvNn9zUoZ8vfHZC2A/PnHZDqQZ3bCkt4= Received: by 10.78.123.4 with SMTP id v4mr18366120huc.18.1199377201762; Thu, 03 Jan 2008 08:20:01 -0800 (PST) Received: by 10.78.35.6 with HTTP; Thu, 3 Jan 2008 08:20:01 -0800 (PST) Message-ID: <162867790801030820w6a150ab8jf63d03e92de449ed@mail.gmail.com> Date: Thu, 3 Jan 2008 17:20:01 +0100 From: "Pavel Stehule" To: "Peter Childs" Subject: Re: Commit takes a long time. Cc: "Postgresql Performance" In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/4 X-Sequence-Number: 28243 Hello On 03/01/2008, Peter Childs 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 > > > >