X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 96E5D11F6249
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Mon, 10 Apr 2006 18:12:24 -0300 (ADT)
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Score: 0.12
X-Spam-Level: 
X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120]
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id EePiZo0-Bj8N
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Mon, 10 Apr 2006 18:11:50 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from my.endian.it (unknown [62.146.87.34])
	by postgresql.org (Postfix) with ESMTP id 76CDA11F628C
	for <pgsql-performance@postgresql.org>;
	Mon, 10 Apr 2006 18:05:37 -0300 (ADT)
Received: from dell.home.lan (host14-128.pool8251.interbusiness.it
	[82.51.128.14]) (authenticated (0 bits))
	by my.endian.it (8.11.6/8.11.6) with ESMTP id k3AM8Qr13524;
	Tue, 11 Apr 2006 00:08:26 +0200
Subject: Re: bad performance on Solaris 10
From: Chris Mair <list@1006.org>
To: Robert Lor <Robert.Lor@Sun.COM>
Cc: Josh Berkus <josh@agliodbs.com>, Mark Kirkwood <markir@paradise.net.nz>,
	pgsql-performance@postgresql.org, llonergan@greenplum.com
In-Reply-To: <1144438174.3729.20.camel@dell.home.lan>
References: <1144111178.3723.80.camel@dell.home.lan>
	<1144279780.5133.19.camel@dell.home.lan>
	<44346DAA.2080905@paradise.net.nz>
	<200604052135.14326.josh@agliodbs.com>
	<1144303269.3718.4.camel@dell.home.lan>  <4434C505.1000205@sun.com>
	<1144438174.3729.20.camel@dell.home.lan>
Content-Type: text/plain
Date: Mon, 10 Apr 2006 23:05:22 +0200
Message-Id: <1144703122.3686.7.camel@dell.home.lan>
Mime-Version: 1.0
X-Mailer: Evolution 2.0.2 (2.0.2-22) 
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200604/219
X-Sequence-Number: 18303


> > Chris,
> > Just to make sure the x4100 config is similar to your Linux system, can 
> > you verify the default setting for disk write cache and make sure they 
> > are both enabled or disabled. Here's how to check in Solaris.
> > As root, run "format -e" -> pick a disk -> cache -> write_cache -> display
> > 
> > Not sure how to do it on Linux though!
> > 
> > Regards,
> > -Robert
> 
> I don't have access to the machine for the next few days due to eh...
> let's call it firewall accident ;), but it might very well be that it
> was off on the x4100 (I know it's on the smaller Linux box).
> 
> That together with the bad default sync method can definitely explain
> the strangely slow out of box performance I got.
> 
> So thanks again for explaining this to me :)
> 
> Bye, Chris.

Just for completeness:
I checked now using the above commands and can confirm the write cache
was disabled on the x4100 and was on on Linux. 

Bye, Chris.