X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0CEDA3A4B9A for ; Sun, 14 Nov 2004 00:14:42 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 14068-05 for ; Sun, 14 Nov 2004 00:14:38 +0000 (GMT) Received: from planae.com.br (nat.planae.com.br [200.210.129.190]) by svr1.postgresql.org (Postfix) with SMTP id ED7B03A4B96 for ; Sun, 14 Nov 2004 00:14:38 +0000 (GMT) Received: (qmail 22889 invoked by uid 1004); 14 Nov 2004 00:14:05 -0000 Received: from 127.0.0.1 by mercurio.planae.com.br (envelope-from , uid 0) with qmail-scanner-1.23 (uvscan: v4.3.20/v4406. Clear:RC:1(127.0.0.1):. Processed in 0.886484 secs); 14 Nov 2004 00:14:04 -0000 Received: from localhost (HELO webmail.planae.com.br) (127.0.0.1) by localhost with SMTP; 14 Nov 2004 00:14:03 -0000 Received: from 10.20.2.50 (SquirrelMail authenticated user gfnobrega@planae.com.br); by webmail.planae.com.br with HTTP; Sat, 13 Nov 2004 22:14:03 -0200 (BRST) Message-ID: <1505.10.20.2.50.1100391243.squirrel@10.20.2.50> In-Reply-To: References: Date: Sat, 13 Nov 2004 22:14:03 -0200 (BRST) Subject: Re: Some quick Opteron 32-bit/64-bit results From: Gustavo Franklin =?iso-8859-1?Q?N=F3brega?= To: "William Yu" Cc: pgsql-performance@postgresql.org User-Agent: SquirrelMail/1.4.3a X-Mailer: SquirrelMail/1.4.3a MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/203 X-Sequence-Number: 9157 Hi Willian, Which are the GCC flags that you it used to compile PostgreSQL? Best regards, Gustavo Franklin Nóbrega Infraestrutura e Banco de Dados Planae Tecnologia da Informação (+55) 14 3224-3066 Ramal 209 www.planae.com.br > I just finished upgrading the OS on our Opteron 148 from Redhat9 to > Fedora FC2 X86_64 with full recompiles of Postgres/Apache/Perl/Samba/etc. > > The verdict: a definite performance improvement. I tested just a few CPU > intensive queries and many of them are a good 30%-50% faster. > Transactional/batch jobs involving client machines (i.e. include fixed > client/networking/odbc overhead) seem to be about 10%-20% faster > although I will need run more data through the system to get a better > feel of the numbers. > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >