pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Josh Rovero <rovero@sonalysts.com>
To: pgsql-performance@postgresql.org
Subject: 8.3.1 vs 8.2.X on HP-UX PA-RISC 11.11/11.23
Date: Wed, 11 Jun 2008 21:40:20 -0400
Message-ID: <20080612014020.431ffdde@mail.sonalysts.com> (raw)

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                    



view thread (3+ messages)  latest in thread

Message-ID: <20080612014020.431ffdde@mail.sonalysts.com>
Permalink:  ../20080612014020.431ffdde@mail.sonalysts.com/
Also on:    postgresql.org/message-id/20080612014020.431ffdde@mail.sonalysts.com

 · 

reply

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: rovero@sonalysts.com
  Subject: Re: 8.3.1 vs 8.2.X on HP-UX PA-RISC 11.11/11.23
  In-Reply-To: <20080612014020.431ffdde@mail.sonalysts.com>

* 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