Re: 8.3.1 vs 8.2.X on HP-UX PA-RISC 11.11/11.23 - Mailing list pgsql-performance

From Kenneth Marshall
Subject Re: 8.3.1 vs 8.2.X on HP-UX PA-RISC 11.11/11.23
Date
Msg-id 20080612122803.GO337@it.is.rice.edu
Whole thread Raw
In response to 8.3.1 vs 8.2.X on HP-UX PA-RISC 11.11/11.23  ("Josh Rovero" <rovero@sonalysts.com>)
Responses Re: 8.3.1 vs 8.2.X on HP-UX PA-RISC 11.11/11.23  (Josh Rovero <rovero@sonalysts.com>)
List pgsql-performance
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
>

pgsql-performance by date:

Previous
From: "Josh Rovero"
Date:
Subject: 8.3.1 vs 8.2.X on HP-UX PA-RISC 11.11/11.23
Next
From: Josh Rovero
Date:
Subject: Re: 8.3.1 vs 8.2.X on HP-UX PA-RISC 11.11/11.23