From: | Marsh Ray <marsh-pg(at)mysteray(dot)com> |
---|---|
To: | "Gregory S(dot) Williamson" <gsw(at)globexplorer(dot)com> |
Cc: | Chris Browne <cbbrowne(at)acm(dot)org>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Raw devices vs. Filesystems |
Date: | 2004-04-07 02:56:38 |
Message-ID: | 40736DE6.6060200@mysteray.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
> gsw(at)globexplorer(dot)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(at)acm(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-04-07 05:26:02 | Re: Raw devices vs. Filesystems |
Previous Message | scott.marlowe | 2004-04-06 22:46:31 | Re: Raw devices vs. Filesystems |