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

От: Kenneth Marshall
Тема: Re: 8.3.1 vs 8.2.X on HP-UX PA-RISC 11.11/11.23
Дата: ,
Msg-id: 20080612122803.GO337@it.is.rice.edu
(см: обсуждение, исходный текст)
Ответ на: 8.3.1 vs 8.2.X on HP-UX PA-RISC 11.11/11.23  ("Josh Rovero")
Ответы: Re: 8.3.1 vs 8.2.X on HP-UX PA-RISC 11.11/11.23  (Josh Rovero)
Список: 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 ()
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>


В списке pgsql-performance по дате сообщения:

От: Josh Rovero
Дата:
Сообщение: Re: 8.3.1 vs 8.2.X on HP-UX PA-RISC 11.11/11.23
От: Uwe Bartels
Дата:
Сообщение: how to find the sql using most of the i/o in an oltp system