X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 72531D1CCCA for ; Mon, 29 Mar 2004 17:21:24 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 85356-06 for ; Mon, 29 Mar 2004 13:21:20 -0400 (AST) Received: from localhost (limacorp.com [66.216.127.144]) by svr1.postgresql.org (Postfix) with SMTP id CCFBDD1BAD3 for ; Mon, 29 Mar 2004 13:21:18 -0400 (AST) Received: (qmail 7048 invoked by uid 506); 29 Mar 2004 17:21:16 -0000 Received: from thampton@limacorp.com by garbanzo.limacorp.com by uid 506 with qmail-scanner-1.16 (spamassassin: 2.55. Clear:. Processed in 0.0362 secs); 29 Mar 2004 17:21:16 -0000 Received: from unknown (HELO limacorp.com) (24.123.167.82) by garbanzo.limacorp.com with SMTP; 29 Mar 2004 17:21:16 -0000 Message-ID: <40685B09.9020702@limacorp.com> Date: Mon, 29 Mar 2004 12:21:13 -0500 From: Terry Hampton User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20021003 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Jaime Casanova Cc: pgsql-admin@postgresql.org Subject: Re: Raw devices vs. Filesystems References: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/373 X-Sequence-Number: 12942 Hello Jaime, I think you're on the right track but have gotten some concepts possibly confused. As I remember, the original email asked if Postgres could be run in a "raw" mode. Another submitter told us that it can not. ( Did I read that correctly, everyone ? ) This means run Postgress in a raw or character mode versus the "standard" block mode as you would handle other files in a filesystem. The primary advantage for a raw mode is speed. ORACLE allows this method of operation. So ... your last question is now rather moot. For best performance assure your setup parameters and Linux kernel parameters are optimized. Help with that is a few keystrokes from anywhere. Terry Jaime Casanova wrote: > Can you tell me (or at least guide me to a palce where i can find the > answer) what are the benefits of filesystems over raw devices? > > And what filesystem is the best for postgresql performance? > -- Terry L. Hampton Project Manager LimaCorp, LLC www.limacorp.com 513.587.1874