Received: from localhost (unknown [200.46.204.183])
	by developer.postgresql.org (Postfix) with ESMTP id 24F662E0096
	for <pgsql-performance-postgresql.org@developer.postgresql.org>;
	Thu, 12 Jun 2008 09:28:17 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 08173-04
	for <pgsql-performance-postgresql.org@developer.postgresql.org>;
	Thu, 12 Jun 2008 09:28:03 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from is.rice.edu (is.rice.edu [128.42.42.24])
	by developer.postgresql.org (Postfix) with ESMTP id BEB9C2E0095
	for <pgsql-performance@postgresql.org>;
	Thu, 12 Jun 2008 09:28:08 -0300 (ADT)
Received: from scan1.mail.rice.edu (scan1.mail.rice.edu [128.42.58.160])
	by is.rice.edu (Postfix) with ESMTP id A2DCF4181D;
	Thu, 12 Jun 2008 07:28:04 -0500 (CDT)
Received: from is.rice.edu ([128.42.42.24])
	by scan1.mail.rice.edu (scan1.mail.rice.edu [128.42.58.160])
	(amavisd-new, port 10024)
	with ESMTP id 03053-04; Thu, 12 Jun 2008 07:28:04 -0500 (CDT)
Received: by is.rice.edu (Postfix, from userid 18612)
	id E86DA41819; Thu, 12 Jun 2008 07:28:03 -0500 (CDT)
Date: Thu, 12 Jun 2008 07:28:03 -0500
From: Kenneth Marshall <ktm@rice.edu>
To: Josh Rovero <rovero@sonalysts.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: 8.3.1 vs 8.2.X on HP-UX PA-RISC 11.11/11.23
Message-ID: <20080612122803.GO337@it.is.rice.edu>
References: <20080612014020.431ffdde@mail.sonalysts.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20080612014020.431ffdde@mail.sonalysts.com>
User-Agent: Mutt/1.5.16 (2007-06-09)
X-Virus-Scanned: by amavis-2.2.1 at scan1.mail.rice.edu
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200806/50
X-Sequence-Number: 30400

Are you using the same locales for both?

Ken

On Wed, Jun 11, 2008 at 09:40:20PM -0400, Josh Rovero wrote:
> We run GCC-compiled postgresql on a number
> of HP-UX and Linux boxes.
> 
> Our measurements to date show 8.3.1
> performance to be about 30% *worse*
> than 8.2 on HP-UX for the same "drink the firehose"
> insert/update/delete benchmarks.  Linux
> performance is fine.  
> 
> Tweaking the new 8.3.1 synchronous_commit
> and bg writer delays that *should* speed
> things up actually makes them a bit worse,
> again only on HP-UX PA-RISK 11.11 and 11.23.
> 
> Right now it's 32 bit, both for 8.2 and 8.3.  
> 
> Any hints?
> 
> 
> 
> P. J. Rovero                    
> 
> -- 
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>