Re: O_DIRECT in freebsd

Personally, I think it is useful to have features.  I quite understand the 
difficulties in maintaining some features however.  Also having worked on 
internals for commercial DB engines, I have specifically how code/data paths 
can be shortened.  I would not make the choice for someone to be forced into 
using a product in a specific manner.  Instead, I would let them decide 
whether to choose a simple setup or, if they are up to it, something with 
better performance.  I would not prune the options out.  In doing so, we 
limit what a knowledgeable person can do a priori.

Jordan Henderson

On Thursday 30 October 2003 19:59, Sailesh Krishnamurthy wrote:
> >>>>> "Jordan" == Jordan Henderson <jordan_henders@yahoo.com> writes:
>
>     Jordan> significantly better results.  I would not say it requires
>     Jordan> considerable tuning, but an understanding of data, storage
>     Jordan> and access patterns.  Additionally, these features did not
>     Jordan> cause our group considerable administrative overhead.
>
> I won't dispute the specifics. I have only worked on the DB2 engine -
> never written an app for it nor administered it. You're right - the
> bottomline is that you can get a significant performance advantage
> provided you care enough to understand what's going on.
>
> Anyway, I merely responded to provide a data point. Will PostgreSQL
> users/administrators care for additional knobs or is there a
> preference for "keep it simple, stupid" ?