From: Marsh Ray <marsh-pg@mysteray.com>
To: Gregory S. Williamson <gsw@globexplorer.com>
Cc: Chris Browne <cbbrowne@acm.org>
Cc: pgsql-admin@postgresql.org
Subject: Re: Raw devices vs. Filesystems
Date: Tue, 06 Apr 2004 22:56:38 -0400
Message-ID: <40736DE6.6060200@mysteray.com> (raw)
In-Reply-To: <71E37EF6B7DCC1499CEA0316A2568328DC9B8E@loki.wc.globexplorer.net>
References: <71E37EF6B7DCC1499CEA0316A2568328DC9B8E@loki.wc.globexplorer.net>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: marsh-pg@mysteray.com, gsw@globexplorer.com, cbbrowne@acm.org
Subject: Re: Raw devices vs. Filesystems
In-Reply-To: <40736DE6.6060200@mysteray.com>
References: <71E37EF6B7DCC1499CEA0316A2568328DC9B8E@loki.wc.globexplorer.net> <40736DE6.6060200@mysteray.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox