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 8BEDBD1E92A for ; Tue, 6 Apr 2004 18:10:07 -0300 (ADT) 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 51438-10 for ; Tue, 6 Apr 2004 18:10:06 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 003A8D1E8FC for ; Tue, 6 Apr 2004 18:10:04 -0300 (ADT) 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 i36LA3Sx094816 for ; Tue, 6 Apr 2004 21:10:03 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i36LA0Qh094624 for pgsql-admin@postgresql.org; Tue, 6 Apr 2004 21:10:00 GMT From: Chris Browne X-Newsgroups: comp.databases.postgresql.admin Subject: Re: Raw devices vs. Filesystems Date: Tue, 06 Apr 2004 16:57:02 -0400 Organization: cbbrowne Computing Inc Lines: 23 Message-ID: <603c7gj04h.fsf@dev6.int.libertyrms.info> References: <71E37EF6B7DCC1499CEA0316A25683280105786A@loki.wc.globexplorer.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.110002 (No Gnus v0.2) XEmacs/21.4 (Security Through Obscurity, linux) Cancel-Lock: sha1:15plkEF3LHVUmqYr2DqVhI1f/Z0= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/96 X-Sequence-Number: 13069 gsw@globexplorer.com ("Gregory S. Williamson") writes: > No point to beating a dead horse (other than the sheer joy of the > thing) since postgres does not have raw device support, but ... raw > devices, at least on solaris, are about 10 times as fast as cooked > file systems for Informix. This might still be a gain for postgres' > performance, but the portability issues remain. That claim seems really rather remarkable. It implies an entirely stunning degree of inefficiency in the implementation of filesystems on Solaris. The amount of indirection involved in walking through i-nodes and such is something I would expect to introduce some percentage of performance loss, but for it to introduce overhead of over 900% presumably implies that Sun (and/or Veritas) got something really horribly wrong. -- select 'cbbrowne' || '@' || 'cbbrowne.com'; http://www.ntlug.org/~cbbrowne/nonrdbms.html Rules of the Evil Overlord #1. "My Legions of Terror will have helmets with clear plexiglass visors, not face-concealing ones."