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 642488B9E20 for ; Tue, 1 Feb 2005 08:51:12 +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 33870-02 for ; Tue, 1 Feb 2005 08:51:02 +0000 (GMT) Received: from anchor-post-36.mail.demon.net (anchor-post-36.mail.demon.net [194.217.242.86]) by svr1.postgresql.org (Postfix) with ESMTP id 4B6A68B9BF5 for ; Tue, 1 Feb 2005 08:51:01 +0000 (GMT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-36.mail.demon.net with esmtp (Exim 4.42) id 1CvtkP-000CSN-LK; Tue, 01 Feb 2005 08:50:59 +0000 Received: from [192.168.1.17] (client17.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 9A4471794F; Tue, 1 Feb 2005 08:50:55 +0000 (GMT) Message-ID: <41FF42EE.1060501@archonet.com> Date: Tue, 01 Feb 2005 08:50:54 +0000 From: Richard Huxton User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Lago, Bruno Almeida do" Cc: pgsql-performance@postgresql.org Subject: Re: Very important choice References: <4AE1514A9BFBEF408F3D8CAE93C4C5B9038A0E88@brvwbansx0008> In-Reply-To: <4AE1514A9BFBEF408F3D8CAE93C4C5B9038A0E88@brvwbansx0008> Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.067 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200502/10 X-Sequence-Number: 10339 Lago, Bruno Almeida do wrote: > Hello my friends, > > I'd like to know (based on your experience and technical details) which OS > is recommended for running PostgreSQL keeping in mind 3 indicators: > > 1 - Performance (SO, Network and IO) > 2 - SO Stability > 3 - File System Integrity The short answer is almost certainly whichever OS you are most familiar with. If you have a problem, you don't want to be learning new details about your OS while fixing it. That rules out FreeBSD for now. What hardware you want to use will affect performance and choice of OS. You'll need to decide what hardware you're looking to use. As far as file-systems are concerned, ext3 seems to be the slowest, and the general feeling seems to be that XFS is perhaps the fastest. In terms of reliability, avoid cutting-edge releases of any file-system - let others test them for you. One thing to consider is how long it takes to recover from a crash - you can run PostgreSQL on ext2, but checking a large disk can take hours after a crash. That's the real benefit of journalling for PG - speed of recovery. -- Richard Huxton Archonet Ltd