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 A48118B9B29 for ; Tue, 1 Feb 2005 10:01:54 +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 44627-03 for ; Tue, 1 Feb 2005 10:01:37 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.196]) by svr1.postgresql.org (Postfix) with ESMTP id 8C39A8B9D00 for ; Tue, 1 Feb 2005 10:01:28 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 67so737330wri for ; Tue, 01 Feb 2005 02:01:29 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:from:to:subject:date:organization:message-id:mime-version:content-type:x-priority:x-msmail-priority:x-mailer:x-mimeole:importance; b=M0konl7x1LR3kr0UrPc10bmZJXkJ73osuKDdL3UVLW2zDIZymvUxMFPISA84LD2u7YbJx7Ln5TzBnkCP/eR8POl6/EoWOqo6dERwL7mIZdMTOljpX2xCfSkM4oA+aigqBI7BhiKLKMmzExj5TBceGquB2yvmdk4LcoxB+xiJZiQ= Received: by 10.54.21.28 with SMTP id 28mr323409wru; Tue, 01 Feb 2005 02:01:28 -0800 (PST) Received: from sbew318anc22 ([200.184.93.96]) by smtp.gmail.com with ESMTP id 35sm317610wra.2005.02.01.02.01.27; Tue, 01 Feb 2005 02:01:28 -0800 (PST) From: "Bruno Almeida do Lago" To: Subject: Very important choice Date: Tue, 1 Feb 2005 08:02:35 -0200 Organization: G&P Message-ID: <000701c50845$2953f1a0$e883f40a@br.gedasgrp> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0008_01C50834.65CB21A0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.126 tagged_above=0 required=5 tests=AWL, HTML_MESSAGE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200502/12 X-Sequence-Number: 10341 This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C50834.65CB21A0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Sorry, I sent this mail message with wrong account and it has been = delayed by the mail system, so I'm resending it.=20 =20 Hello my friends, =20 I'd like to know (based on your experience and technical details) which = OS is recommended for running PostgreSQL keeping in mind 3 indicators: =20 1 - Performance (SO, Network and IO) 2 - SO Stability 3 - File System Integrity =20 Comparisons between Slackware, Gentoo and FreeBSD are welcome. =20 Which file system has the best performance and integrity: XFS (Linux) or = UFS (FreeBSD)?=20 *I've read that UFS is not a journaling FS. Is this right? How much this difference affects performance and integrity? =20 I don't have experience with FreeBSD so I'd like to know if it is = possible to run XFS on FreeBSD 5.3. =20 =20 Thank you, Bruno Almeida do Lago =20 ------=_NextPart_000_0008_01C50834.65CB21A0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Sorry, I sent this mail message with wrong account = and it has been delayed by the mail system, so I’m resending it. =

 

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

 

Comparisons between Slackware, Gentoo and FreeBSD are welcome.

 

Which file system has the best performance and = integrity: XFS (Linux) or UFS (FreeBSD)?

*I've read that UFS is not a journaling FS. Is this = right? How much this difference affects performance and = integrity?

 

I don't have experience with FreeBSD so I'd like to = know if it is possible to run XFS on FreeBSD 5.3.

 

 

Thank you,

Bruno Almeida do Lago

 

------=_NextPart_000_0008_01C50834.65CB21A0--