Re: [GENERAL] Postgres vs commercial products - Mailing list pgsql-general

From James Olin Oden
Subject Re: [GENERAL] Postgres vs commercial products
Date
Msg-id 81Jul27.072548edt.35713@gateway.lee.k12.nc.us
Whole thread Raw
In response to Re: [GENERAL] Postgres vs commercial products  (The Hermit Hacker <scrappy@hub.org>)
Responses Re: [GENERAL] Postgres vs commercial products  (Wilson MacGyver <macgyver@ruri.cylatech.com>)
List pgsql-general
>         The other problem with trying to implement RAW devices, and,
> granted, I could be over cmplicating it, but how do you implement it
> across X operating systems running Y platforms?  Doesn't each of them
> access drives differently?  And, in some cases, multiply that by two for
> IDE vs SCSI...or...vs...?

  That is the real problem.  I have to assume whenever you start implementing raw
devices, you go far far away from DBMS design to OS design.  Perhaps you do not
have to write the process control part of an OS, but (I mean this jokingly) in
one's arrogance one must think you can access the HD's more efficiently than the
OS can.  Hey, maybe some can do this, and have enough knowledge about HD's and
controllers to do this, but making this portable is got to a _lot_ of work.

Not that it couldn't be done, or that it wouldn't be eventually a good idea
(*though I am not certain about that)...james


pgsql-general by date:

Previous
From: Herouth Maoz
Date:
Subject: Re: [GENERAL] Postgres vs commercial products
Next
From: Chris Johnson
Date:
Subject: Re: [GENERAL] How to know when to vacuum