X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id D8C66D1B524 for ; Wed, 13 Aug 2003 11:49:12 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 03807-10 for ; Wed, 13 Aug 2003 08:47:40 -0300 (ADT) Received: from news.hub.org (unknown [64.117.224.194]) by svr1.postgresql.org (Postfix) with ESMTP id 44AD4D1B52C for ; Wed, 13 Aug 2003 08:49:02 -0300 (ADT) Received: from news.hub.org (host-64-117-224-194.altec1.com [64.117.224.194] (may be forged)) by news.hub.org (8.12.9/8.12.9) with ESMTP id h7DBn1ek062961 for ; Wed, 13 Aug 2003 11:49:02 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id h7DBRS2c057845 for pgsql-performance@postgresql.org; Wed, 13 Aug 2003 11:27:28 GMT From: Christopher Browne X-Newsgroups: comp.databases.postgresql.performance Subject: Re: Perfomance Tuning Date: Tue, 12 Aug 2003 17:43:29 -0400 Organization: cbbrowne Computing Inc Lines: 33 Message-ID: References: <71E37EF6B7DCC1499CEA0316A25683280105705B@loki.globexplorer.com> 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 X-Emacs-Acronym: Embarrassingly Mundane Advertising Cuts Sales Microsoft: We've got the solution for the problem we sold you. X-Uboat-Death-Message: NETSCAPE. ATTACKED. LEAVE BOAT. U-86. User-Agent: Gnus/5.1003 (Gnus v5.10.3) XEmacs/21.4 (Rational FORTRAN, linux) Cancel-Lock: sha1:2WRqMdi41uN5e2llTBmEpO2bSn8= To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/231 X-Sequence-Number: 3048 Martha Stewart called it a Good Thing whengsw@globexplorer.com ("Gregory S. Williamson")wrote: > FWIW, Informix can be run using a "cooked" (Unix) file for storing > data or it uses "raw" disk space and bypasses the ordinary (high > level) UNIX controllers and does its own reads/writes. About 10 > times faster and safer. Of course, itmay have taken a lot of > programmer time to make that solid. But the performance gains are > significant. Are you _certain_ that's still true? Have you a metric that shows Informix being 10x faster on a modern system? That would be quite surprising... It may have been true on '80s style UFS implementations, but a couple of decades have passed, and pretty much any Unix system has new selections of filesystems that probably aren't so much slower. It could conceivably be an interesting idea to implement a block-oriented filesystem where the granularity of files was 8K (or some such number :-)). Oracle seems to have done something vaguely like this... http://otn.oracle.com/tech/linux/open_source.html But long and short is that the guys implementing OSes have been putting a LOT of effort into making the potential performance gains of using "raw" partitions less and less. -- select 'cbbrowne' || '@' || 'acm.org'; http://www.ntlug.org/~cbbrowne/sap.html (eq? 'truth 'beauty) ; to avoid unassigned-var error, since compiled code ; will pick up previous value to var set!-ed, ; the unassigned object. -- from BBN-CL's cl-parser.scm