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 3C99152841 for ; Tue, 24 May 2005 02:57:15 -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 33095-07 for ; Tue, 24 May 2005 05:57:06 +0000 (GMT) Received: from p15154245.pureserver.info (www.forth-edv-services.de [82.165.34.16]) by svr1.postgresql.org (Postfix) with ESMTP id 74E7D5282B for ; Tue, 24 May 2005 02:57:03 -0300 (ADT) Received: from www.nachrichten-zentrale.net (localhost.localdomain [127.0.0.1]) by p15154245.pureserver.info (Postfix) with ESMTP id 4FBB9C0263E; Tue, 24 May 2005 07:57:02 +0200 (CEST) Received: from 193.194.7.77 (SquirrelMail authenticated user rainerb); by www.nachrichten-zentrale.net with HTTP; Tue, 24 May 2005 07:57:02 +0200 (CEST) Message-ID: <57416.193.194.7.77.1116914222.squirrel@193.194.7.77> In-Reply-To: <20050523190248.GE19075@asu.edu> References: <20050523190248.GE19075@asu.edu> Date: Tue, 24 May 2005 07:57:02 +0200 (CEST) Subject: Re: possible os recommendations From: "Rainer J. H. Brandt" To: David.Bear@asu.edu Cc: pgsql-admin@postgresql.org Reply-To: rjhb@bb-c.de User-Agent: SquirrelMail/1.4.3-RC1 X-Mailer: SquirrelMail/1.4.3-RC1 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.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200505/271 X-Sequence-Number: 17700 Hello, > 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. > > I would really like to hear from those who have used postgresql on > multiple operating systems.. I've used PostgreSQL on lots of Unixes. Most of the advantages and disadvantages of those are not database-specific. Here are some pro's of each of them: BSDs: centralized, well-organized code management, code well thought-out and readable, especially NetBSD. Good performance and reliability. Linux: supports hardware faster, so if you want to play video games or have rare network cards, use this. Mac OS: pleasing user interface, easier administration for non-technicians, good performance Solaris: superior OS architecture and features, esp. in Solaris 10 (unbeatable diagnostics with dtrace/mdb), high degree of automization (hands-off installation and configuration of everything) Notice: BSD, Linux, and Solaris cost nothing. Mac OS is payware. Sources are available for BSDs, Linux, Mac OS (the "Unix" subset), and (within the next 5 weeks) Solaris. So, if you're a professional, go with NetBSD or Solaris. If you want a system that your grandparents (may they still be living) feel comfortable with, take Mac OS X. Greetings, Rainer