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
Date: Thu, 12 Jun 2008 07:28:03 -0500
Message-ID: <20080612122803.GO337@it.is.rice.edu> (raw)
In-Reply-To: <20080612014020.431ffdde@mail.sonalysts.com>
References: <20080612014020.431ffdde@mail.sonalysts.com>
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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ktm@rice.edu, rovero@sonalysts.com
Subject: Re: 8.3.1 vs 8.2.X on HP-UX PA-RISC 11.11/11.23
In-Reply-To: <20080612122803.GO337@it.is.rice.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox