Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 5288E2E3ADB for ; Tue, 22 Jan 2008 04:49:07 -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 79695-10 for ; Tue, 22 Jan 2008 04:49:01 -0400 (AST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.181]) by postgresql.org (Postfix) with ESMTP id DA2802E3AD9 for ; Tue, 22 Jan 2008 04:49:03 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id m38so4521234waf.5 for ; Tue, 22 Jan 2008 00:49: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=sYTuGXyfrHJ/kipX/v9FVo9Uy+ehltc6GrEPxEJf4X0=; b=s4s5DM96EzKqxMPjwkdA8g2KuIdBUo71T69msMf5sKc88v5q7UC/9RzOCYAG6U1PYhjc0d3k+txDJDDlhU3wJWkuDCJc/OojgBv++YYZuNu90xY56vjyB7WVXmSynIf2JkDJnlnZaSIHgHTA+euOjcxwoYaSJaQPhEntmc7KMG0= 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=HSRyr4pU34Ur+1xqxjM52P+DjJsPVyfWxpd4XWs7RWxUAh5LcYWKyH3Uk6X/OHNpqtTLdSKPMZt37NIbh4UhTjLTHmUaM5Rt66mxJBHp+hNazOOSBXep22Zo1C1NyGOsXMblH4uwoG6cKmiwVE5Fh3/OFB3icx6JDMIDEKzz5JI= Received: by 10.115.108.1 with SMTP id k1mr6391194wam.141.1200991742493; Tue, 22 Jan 2008 00:49:02 -0800 (PST) Received: by 10.114.155.9 with HTTP; Tue, 22 Jan 2008 00:49:02 -0800 (PST) Message-ID: <1d4e0c10801220049p7b184a52s1b2b2e86bc414395@mail.gmail.com> Date: Tue, 22 Jan 2008 09:49:02 +0100 From: "Guillaume Smet" To: "Florian Weimer" Subject: Re: 8.3 synchronous_commit Cc: "Hannes Dorbath" , pgsql-performance@postgresql.org In-Reply-To: <82d4rumfae.fsf@mid.bfk.de> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <82d4rumfae.fsf@mid.bfk.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/176 X-Sequence-Number: 28415 On Jan 22, 2008 9:32 AM, Florian Weimer wrote: > > Maybe it's just my test box.. single SATA-II drive, XFS on top of LVM. > > Ours was ext3, no LVM or RAID. Also with SATA? If your SATA disk is lying about effectively SYNCing the data, I'm not that surprised you don't see any improvement. Being slower is a bit surprising though. -- Guillaume