Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 70D5D2E0140 for ; Thu, 12 Jun 2008 10:25:59 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 61681-01-5 for ; Thu, 12 Jun 2008 10:25:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from p02c11o141.mxlogic.net (p02c11o141.mxlogic.net [208.65.144.74]) by developer.postgresql.org (Postfix) with ESMTP id 72D892E02D0 for ; Thu, 12 Jun 2008 09:54:37 -0300 (ADT) Received: from unknown [198.6.208.103] (EHLO p02c11o141.mxlogic.net) by p02c11o141.mxlogic.net (mxl_mta-5.5.0-3) with ESMTP id d8c11584.2670996400.340851.00-526.p02c11o141.mxlogic.net (envelope-from ); Thu, 12 Jun 2008 06:54:37 -0600 (MDT) Received: from unknown [198.6.208.103] (EHLO mail.sonalysts.com) by p02c11o141.mxlogic.net (mxl_mta-5.5.0-3) with ESMTP id 78c11584.2744425392.340839.00-007.p02c11o141.mxlogic.net (envelope-from ); Thu, 12 Jun 2008 06:54:31 -0600 (MDT) Received: from localhost ([127.0.0.1]) by mail.sonalysts.com (using TLSv1/SSLv3 with cipher AES256-SHA (256 bits)); Thu, 12 Jun 2008 08:54:28 -0400 Message-ID: <48511C83.8000607@sonalysts.com> Date: Thu, 12 Jun 2008 08:54:27 -0400 From: Josh Rovero Organization: Sonalysts, Inc. User-Agent: Thunderbird 1.5 (X11/20051201) MIME-Version: 1.0 To: Kenneth Marshall CC: pgsql-performance@postgresql.org Subject: Re: 8.3.1 vs 8.2.X on HP-UX PA-RISC 11.11/11.23 References: <20080612014020.431ffdde@mail.sonalysts.com> <20080612122803.GO337@it.is.rice.edu> In-Reply-To: <20080612122803.GO337@it.is.rice.edu> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Spam: [F=0.2000000000; S=0.200(2008052701)] X-MAIL-FROM: X-SOURCE-IP: [198.6.208.103] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200806/51 X-Sequence-Number: 30401 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 ***********************************************************************