Remarkable, perhaps, to you. Not in the Informix world. But irrelevant to postgres, no ?
-----Original Message-----
From: Chris Browne [mailto:cbbrowne@acm.org]
Sent: Tuesday, April 06, 2004 1:57 PM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Raw devices vs. Filesystems
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."
<http://www.eviloverlord.com/>
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster