Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 7E8B11337A67
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue, 10 May 2011 06:45:04 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 95243-04
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue, 10 May 2011 09:44:47 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from elizabeth.gransy.com (elizabeth.gransy.com [89.187.132.199])
	by mail.postgresql.org (Postfix) with ESMTP id E4C9A133740B
	for <pgsql-performance@postgresql.org>;
	Tue, 10 May 2011 06:44:46 -0300 (ADT)
Received: from sq.gransy.com (localhost [127.0.0.1])
	by elizabeth.gransy.com (Postfix) with ESMTP id F1EF715E4358;
	Tue, 10 May 2011 11:44:45 +0200 (CEST)
Received: from 85.160.144.191 (SquirrelMail authenticated user tv@fuzzy.cz)
	by sq.gransy.com with HTTP; Tue, 10 May 2011 11:44:46 +0200
Message-ID: <53eef814d1a20e20fe059ff7298774f1.squirrel@sq.gransy.com>
In-Reply-To: <BANLkTimRRj1KX5YXWyjcc9wQZJuEMgxAsA@mail.gmail.com>
References: <BANLkTimRRj1KX5YXWyjcc9wQZJuEMgxAsA@mail.gmail.com>
Date: Tue, 10 May 2011 11:44:46 +0200
Subject: Re: 8.2.13 commit is taking too much time
From: tv@fuzzy.cz
To: "AI Rumman" <rummandba@gmail.com>
Cc: pgsql-performance@postgresql.org
User-Agent: SquirrelMail/1.4.21
MIME-Version: 1.0
Content-Type: text/plain;charset=utf-8
Content-Transfer-Encoding: 8bit
X-Priority: 3 (Normal)
Importance: Normal
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9
X-Spam-Level: 
X-Archive-Number: 201105/122
X-Sequence-Number: 43631


> Any idea how to improve the performance?

Hmmm, I guess we'll need more info about resource usage (CPU, I/O, locks)
used when the commit happens. Run these two commands

$ iostat -x 1
$ vmstat 1

and then execute the commit. See what's causing problems. Is the drive
utilization close to 100%? You've problems with disks (I'd bet this is the
cause). Etc.

There's a very nice chapter about this in Greg's book.

BTW what filesystem are you using? Ext3, ext4, reiserfs, xfs? I do
remember there were some problems with sync, that some filesystems are
unable to sync individual files and always sync everything (which is going
to suck if you want to sync just the WAL).

regards
Tomas