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 51B5FD1E86C for ; Mon, 29 Mar 2004 17:23:14 +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 87143-05 for ; Mon, 29 Mar 2004 13:23:11 -0400 (AST) Received: from localhost (limacorp.com [66.216.127.144]) by svr1.postgresql.org (Postfix) with SMTP id BA730D1CCB4 for ; Mon, 29 Mar 2004 13:23:09 -0400 (AST) Received: (qmail 7118 invoked by uid 506); 29 Mar 2004 17:23:08 -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.024436 secs); 29 Mar 2004 17:23:08 -0000 Received: from unknown (HELO limacorp.com) (24.123.167.82) by garbanzo.limacorp.com with SMTP; 29 Mar 2004 17:23:08 -0000 Message-ID: <40685B79.9050901@limacorp.com> Date: Mon, 29 Mar 2004 12:23:05 -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: pgsql-admin@postgresql.org Subject: Raw vs Filesystem 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/374 X-Sequence-Number: 12943 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