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 9C8D0D1EB09 for ; Tue, 30 Mar 2004 04:50:31 +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 55630-04 for ; Tue, 30 Mar 2004 00:50:30 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 44321D1CACF for ; Tue, 30 Mar 2004 00:50:29 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i2U4oSYn009365 for ; Tue, 30 Mar 2004 04:50:28 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i2U4oSNQ009361 for pgsql-admin@postgresql.org; Tue, 30 Mar 2004 04:50:28 GMT From: Christopher Browne X-Newsgroups: comp.databases.postgresql.admin Subject: Re: Raw vs Filesystem Date: Mon, 29 Mar 2004 23:00:32 -0500 Organization: cbbrowne Computing Inc Lines: 24 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1006 (Gnus v5.10.6) XEmacs/21.4 (Security Through Obscurity, linux) Cancel-Lock: sha1:tCcY8DP2EL61wcv+BU4QmTtw2Bo= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/49 X-Sequence-Number: 13022 el_vigia_ec@hotmail.com ("Jaime Casanova") asked: > so, the real question is what is the best filesystem for optimal speed > in postgresql? The smart-alec answer would be... "Veritas, of course!" But seriously, it depends on many factors you have not provided information about. -> Different operating systems support different filesystems; you should probably specify what OS you are using. -> Hardware choices have ENORMOUSLY more impact on speed than any choice of filesystems. If your hardware is too slow, changing filesystems will not help you. And you would be _way_ better off with a filesystem that is 3% slower if it improves reliability by a significant factor. -- wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','acm.org'). http://www3.sympatico.ca/cbbrowne/lsf.html "We should start referring to processes which run in the background by their correct technical name:... paenguins." -- Kevin M Bealer