Message-ID: <4C11287A.90406@commandprompt.com>
Date: Thu, 10 Jun 2010 11:01:30 -0700
From: Lacey Powers <lacey.powers@commandprompt.com>
User-Agent: Thunderbird 2.0.0.24 (X11/20100411)
MIME-Version: 1.0
To: Alvaro Herrera <alvherre@commandprompt.com>
CC: Tom Lane <tgl@sss.pgh.pa.us>, Max Williams <max.williams@mflow.com>,
	"pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Subject: Re: Large (almost 50%!) performance drop after upgrading
 to 8.4.4?
References: 
 <0357196CB603794BB76F4F6B373F27330506EACE45@SERVER.ddnglobal.local>
	<AANLkTilfB0IIBqN8MG_vCPDba0R2NxcXgjIM7Axj61wM@mail.gmail.com>
	<1276158598.5764.22.camel@hp-laptop2.gunduz.org>
	<0357196CB603794BB76F4F6B373F27330506EACE51@SERVER.ddnglobal.local>
	<15383.1276179056@sss.pgh.pa.us>
	<0357196CB603794BB76F4F6B373F27330506EACE55@SERVER.ddnglobal.local>
	<4C10BB59020000250003214A@gw.wicourts.gov>
	<0357196CB603794BB76F4F6B373F27330506EACE56@SERVER.ddnglobal.local>
	<17509.1276184785@sss.pgh.pa.us>
	<1276187560-sup-6778@alvh.no-ip.org>
In-Reply-To: <1276187560-sup-6778@alvh.no-ip.org>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Alvaro Herrera wrote:
> Excerpts from Tom Lane's message of jue jun 10 11:46:25 -0400 2010:
>
>> Yes, the folks at commandprompt need to be told about this.  Loudly.
>> It's a serious packaging error.
>
> Just notified Lacey, the packager (not so loudly, though); she's working
> on new packages, and apologizes for the inconvenience.
>

Hello Everyone,

New packages for 8.4.4 on CentOS 5.5 and RHEL 5.5 (all arches), have 
been built, and are available in the PGDG repo.

http://yum.pgsqlrpms.org/8.4/redhat/rhel-5-i386/
http://yum.pgsqlrpms.org/8.4/redhat/rhel-5-x86_64/

Output from pg_config --configure --version is below.

x86_64:

'--build=x86_64-redhat-linux-gnu' '--host=x86_64-redhat-linux-gnu' 
'--target=x86_64-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' 
'--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' 
'--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' 
'--libdir=/usr/lib64' '--libexecdir=/usr/libexec' '--localstatedir=/var' 
'--sharedstatedir=/usr/com' '--mandir=/usr/share/man' 
'--infodir=/usr/share/info' '--disable-rpath' '--with-perl' 
'--with-python' '--with-tcl' '--with-tclconfig=/usr/lib64' 
'--with-openssl' '--with-pam' '--with-krb5' '--with-gssapi' 
'--with-includes=/usr/include' '--with-libraries=/usr/lib64' 
'--enable-nls' '--enable-thread-safety' '--with-libxml' '--with-libxslt' 
'--with-ldap' '--with-system-tzdata=/usr/share/zoneinfo' 
'--sysconfdir=/etc/sysconfig/pgsql' '--datadir=/usr/share/pgsql' 
'--with-docdir=/usr/share/doc' 'build_alias=x86_64-redhat-linux-gnu' 
'host_alias=x86_64-redhat-linux-gnu' 
'target_alias=x86_64-redhat-linux-gnu' 'CFLAGS=-O2 -g -pipe -Wall 
-Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector 
--param=ssp-buffer-size=4 -m64 -mtune=generic -I/usr/include/et' 
'CPPFLAGS= -I/usr/include/et'
PostgreSQL 8.4.4

i386:

'--build=i686-redhat-linux-gnu' '--host=i686-redhat-linux-gnu' 
'--target=i386-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' 
'--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' 
'--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' 
'--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' 
'--sharedstatedir=/usr/com' '--mandir=/usr/share/man' 
'--infodir=/usr/share/info' '--disable-rpath' '--with-perl' 
'--with-python' '--with-tcl' '--with-tclconfig=/usr/lib' 
'--with-openssl' '--with-pam' '--with-krb5' '--with-gssapi' 
'--with-includes=/usr/include' '--with-libraries=/usr/lib' 
'--enable-nls' '--enable-thread-safety' '--with-libxml' '--with-libxslt' 
'--with-ldap' '--with-system-tzdata=/usr/share/zoneinfo' 
'--sysconfdir=/etc/sysconfig/pgsql' '--datadir=/usr/share/pgsql' 
'--with-docdir=/usr/share/doc' 'build_alias=i686-redhat-linux-gnu' 
'host_alias=i686-redhat-linux-gnu' 'target_alias=i386-redhat-linux-gnu' 
'CFLAGS=-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions 
-fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386 
-mtune=generic -fasynchronous-unwind-tables -I/usr/include/et' 
'CPPFLAGS= -I/usr/include/et'
PostgreSQL 8.4.4

Again, I extend deep apologies for the inconvenience.

If there is anything further we can help with, please let us know.

Regards,

Lacey

-- 
Lacey Powers

The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 ext 104
PostgreSQL Replication, Consulting, Custom Development, 24x7 support