X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4110152896 for ; Mon, 23 May 2005 16:50:56 -0300 (ADT) 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 90696-08 for ; Mon, 23 May 2005 19:50:47 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id 4D4555287C for ; Mon, 23 May 2005 16:50:44 -0300 (ADT) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 23 May 2005 14:50:44 -0500 Subject: Re: possible os recommendations From: Scott Marlowe To: David.Bear@asu.edu Cc: pgsql-admin@postgresql.org In-Reply-To: <20050523190248.GE19075@asu.edu> References: <20050523190248.GE19075@asu.edu> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1116877844.31821.222.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Mon, 23 May 2005 14:50:44 -0500 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.005 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200505/268 X-Sequence-Number: 17697 On Mon, 2005-05-23 at 14:02, David Bear wrote: > wanting to avoid religious warfare, I'm curious if there may be some > who would have recommendations for what operating system is 'best' to SNIP > I'm more concerned though about the complete experience, i.e. > postgresql performance on Linux vs Bsd vs Windows... > Maintainability.. Stability... os tweeks that were really needed to > make pg work well, etc. There's not a lot of difference between running postgresql on BSD versus Linux for most people. As long as you or your sysadmin is reasonably familiar with whichever you're running on, they should work fine. Some folks choose to run PostgreSQL on commercial OSes like Solaris or AIX, primarily for it's ability to support hot swappable and high availability hardware. Generally speaking, a Very fast two CPU machine running on AMD-64s with the latest and greatest FreeBSD or Linux kernel is likely to outrun most of the big iron machines, they just don't provide the 99.999 reliability. The Windows port of PostgreSQL is just too new to be considered as an equal to the unix or other ports. Plus, the things needed to make PostgreSQL competitive on Windows aren't likely to show up any time soon, since stability is the main focus of such a new port right now. Your hardware and quality hardware drivers for your given OS are probably just as important as the amount of memory and CPU speed you throw at things. This is especially true of your RAID controller, it's cache, and the number of hard drives you can throw at the problem. Generally speaking, BSD handles lots of processes and file system I/O better, while Linux handles CPU / memory intensive apps a little better. But the difference is small to nil, depending.