pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (17+ messages)  latest in thread

Message-ID: <40736DE6.6060200@mysteray.com>
Permalink:  ../40736DE6.6060200@mysteray.com/
Also on:    postgresql.org/message-id/40736DE6.6060200@mysteray.com

 · 

reply

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