Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id F1AF79FB693 for ; Mon, 7 May 2007 19:14:22 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 33661-09 for ; Mon, 7 May 2007 19:14:15 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id 1C8A29FB691 for ; Mon, 7 May 2007 19:14:18 -0300 (ADT) Received: from [192.168.1.2] (or-67-76-146-141.sta.embarqhsd.net [67.76.146.141]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l47MEI62007926; Mon, 7 May 2007 15:14:18 -0700 Message-ID: <463FA4B0.7020006@commandprompt.com> Date: Mon, 07 May 2007 15:14:08 -0700 From: "Joshua D. Drake" User-Agent: Thunderbird 2.0.0.0 (Windows/20070326) MIME-Version: 1.0 To: Bill Moran CC: David Levy , pgsql-performance@postgresql.org Subject: Re: Best OS for Postgres 8.2 References: <1178574927.533849.90730@e51g2000hsg.googlegroups.com> <463FA136.3030204@commandprompt.com> <20070507180401.033fbc38.wmoran@collaborativefusion.com> In-Reply-To: <20070507180401.033fbc38.wmoran@collaborativefusion.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.88.5, clamav-milter version 0.88.5 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Mon, 07 May 2007 15:14:19 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/75 X-Sequence-Number: 24465 Bill Moran wrote: > In response to "Joshua D. Drake" : > >> David Levy wrote: >>> Hi, >>> >>> I am about to order a new server for my Postgres cluster. I will >>> probably get a Dual Xeon Quad Core instead of my current Dual Xeon. >>> Which OS would you recommend to optimize Postgres behaviour (i/o >>> access, multithreading, etc) ? >>> >>> I am hesitating between Fedora Core 6, CentOS and Debian. Can anyone >>> help with this ? >> Well you just described three linux distributions, which is hardly a >> question about which OS to use ;). I would stick with the long supported >> versions of Linux, thus CentOS 5, Debian 4, Ubuntu Dapper. > > There used to be a prominent site that recommended FreeBSD for Postgres. > Don't know if that's still recommended or not -- but bringing it up is > likely to start a Holy War. Heh... I doubt it will start a war. FreeBSD is a good OS. However, I specifically noted the Dual Xeon Quad Core, which means, 8 procs. It is my understanding (and I certainly could be wrong) that FreeBSD doesn't handle SMP nearly as well as Linux (and Linux not as well as Solaris). Sincerely, Joshua D. Drake >