pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feed8.3.1 vs 8.2.X on HP-UX PA-RISC 11.11/11.23
3+ messages / 2 participants
[nested] [flat]
* 8.3.1 vs 8.2.X on HP-UX PA-RISC 11.11/11.23
@ 2008-06-12 01:40 Josh Rovero <rovero@sonalysts.com>
0 siblings, 1 reply; 3+ messages in thread
From: Josh Rovero @ 2008-06-12 01:40 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: 8.3.1 vs 8.2.X on HP-UX PA-RISC 11.11/11.23
@ 2008-06-12 12:28 Kenneth Marshall <ktm@rice.edu>
parent: Josh Rovero <rovero@sonalysts.com>
0 siblings, 1 reply; 3+ messages in thread
From: Kenneth Marshall @ 2008-06-12 12:28 UTC (permalink / raw)
To: Josh Rovero <rovero@sonalysts.com>; +Cc: 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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: 8.3.1 vs 8.2.X on HP-UX PA-RISC 11.11/11.23
@ 2008-06-12 12:54 Josh Rovero <rovero@sonalysts.com>
parent: Kenneth Marshall <ktm@rice.edu>
0 siblings, 0 replies; 3+ messages in thread
From: Josh Rovero @ 2008-06-12 12:54 UTC (permalink / raw)
To: Kenneth Marshall <ktm@rice.edu>; +Cc: pgsql-performance
Yes. Locale is 'C' for both 8.3.1 and 8.2.1.
Kenneth Marshall wrote:
> 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.
--
P. J. "Josh" Rovero Sonalysts, Inc.
Email: rovero@sonalysts.com www.sonalysts.com 215 Parkway North
Work: (860)326-3671 or 442-4355 Waterford CT 06385
***********************************************************************
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-06-12 12:54 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-06-12 01:40 8.3.1 vs 8.2.X on HP-UX PA-RISC 11.11/11.23 Josh Rovero <rovero@sonalysts.com>
2008-06-12 12:28 ` Kenneth Marshall <ktm@rice.edu>
2008-06-12 12:54 ` Josh Rovero <rovero@sonalysts.com>
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