Обсуждение: 8.3.1 vs 8.2.X on HP-UX PA-RISC 11.11/11.23
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
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 >
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 ***********************************************************************