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 896483A3BE0 for ; Fri, 5 Nov 2004 18:23:31 +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 13979-10 for ; Fri, 5 Nov 2004 18:23:21 +0000 (GMT) Received: from mail.3gstech.com (ns1.mcdownloads.com [216.239.132.98]) by svr1.postgresql.org (Postfix) with ESMTP id 9A7123A3E07 for ; Fri, 5 Nov 2004 18:23:21 +0000 (GMT) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.3gstech.com (Postfix) with ESMTP id 7FC81A16FC5; Fri, 5 Nov 2004 10:23:20 -0800 (PST) Received: from mail.3gstech.com ([127.0.0.1]) by localhost (fungus [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 08201-03; Fri, 5 Nov 2004 10:23:20 -0800 (PST) Received: from [216.239.128.141] (daniel.omnis.com [216.239.128.141]) by mail.3gstech.com (Postfix) with ESMTP id 656E8A16FC4; Fri, 5 Nov 2004 10:23:20 -0800 (PST) Message-ID: <418BC518.2050909@omnis.com> Date: Fri, 05 Nov 2004 10:23:20 -0800 From: Daniel Ceregatti Organization: Omnis Network User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.3) Gecko/20040916 MultiZilla/1.6.3.1a X-Accept-Language: en-us, en MIME-Version: 1.0 To: Merlin Moncure Cc: pgsql-performance@postgresql.org Subject: Re: postgresql amd-64 References: <6EE64EF3AB31D5448D0007DD34EEB3412A7518@Herge.rcsinc.local> In-Reply-To: <6EE64EF3AB31D5448D0007DD34EEB3412A7518@Herge.rcsinc.local> X-Enigmail-Version: 0.86.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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/104 X-Sequence-Number: 9058 I have two dual opteron 248's with 4g of ram each, 6x36G 15k rpm ultra 320 scsi disks in hardware raid 5, and they are by far the fastest machines I've user used. As far as this "headache" of using 64 bit Linux, I've experienced no such thing. I'm using gentoo on both machines, which are dedicated for postgres 7.4 and replicated with slony. They're both quite fast and reliable. One machine even runs a secondary instance of pg, pg 8 beta4 in this case, for development, which also runs quite well. Daniel Merlin Moncure wrote: >Does anybody have any experiences with postgresql 7.4+ running on amd-64 >in 64 bit mode? Specifically, does it run quicker and if so do the >performance benefits justify the extra headaches running 64 bit linux? > >Right now I'm building a dual Opteron 246 with 4 gig ddr400. > >Merlin > >---------------------------(end of broadcast)--------------------------- >TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html > > -- Daniel Ceregatti - Programmer Omnis Network, LLC The forest is safe because a lion lives therein and the lion is safe because it lives in a forest. Likewise the friendship of persons rests on mutual help. -- Laukikanyay.