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 6EFAAD1CC93 for ; Tue, 6 Apr 2004 23:56:40 -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 67302-04 for ; Tue, 6 Apr 2004 23:56:42 -0300 (ADT) Received: from imf25aec.mail.bellsouth.net (imf25aec.mail.bellsouth.net [205.152.59.73]) by svr1.postgresql.org (Postfix) with ESMTP id DA261D1CB3F for ; Tue, 6 Apr 2004 23:56:37 -0300 (ADT) Received: from cookie.local.dns ([68.214.121.106]) by imf25aec.mail.bellsouth.net (InterMail vM.5.01.06.08 201-253-122-130-108-20031117) with SMTP id <20040407025642.GXDW1763.imf25aec.mail.bellsouth.net@cookie.local.dns> for ; Tue, 6 Apr 2004 22:56:42 -0400 Received: (qmail 23959 invoked from network); 7 Apr 2004 02:56:41 -0000 Received: from grover.local.dns (HELO mysteray.com) (192.168.17.52) by cookie.local.dns with SMTP; 7 Apr 2004 02:56:41 -0000 Message-ID: <40736DE6.6060200@mysteray.com> Date: Tue, 06 Apr 2004 22:56:38 -0400 From: Marsh Ray User-Agent: Mozilla Thunderbird 0.5 (Windows/20040207) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Gregory S. Williamson" Cc: Chris Browne , pgsql-admin@postgresql.org Subject: Re: Raw devices vs. Filesystems References: <71E37EF6B7DCC1499CEA0316A2568328DC9B8E@loki.wc.globexplorer.net> In-Reply-To: <71E37EF6B7DCC1499CEA0316A2568328DC9B8E@loki.wc.globexplorer.net> 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: 200404/99 X-Sequence-Number: 13072 > 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. > From: Chris Browne [mailto:cbbrowne@acm.org] > 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. Gregory S. Williamson wrote: > Remarkable, perhaps, to you. Not in the Informix world. But > irrelevant to postgres, no ? I too am a little surprised by those numbers, but I think the potential for a performance gain of that order is relevant. As I once heard someone remark: "When show up at a pool hall talking those kind of odds, well, people start making phone calls." - Marsh