Greg: Thank you very much for your insightful comments on the performance of
direct io applied to postgres! That inspired me a lot.
Tom: thank you for the reference to man page!
On Fri, Jun 18, 2010 at 2:02 AM, Greg Smith g...@2ndquadrant.com wrote:
Daniel Ng wrote:
I am trying to enable the direct IO for the disk-resident
hash partitions of hashjoin in postgresql.
As Tom already mentioned this isn't working because of alignment issues.
I'm not sure what you expect to achieve though. You should be warned that
other than the WAL, every experiment I've ever seen that tries to add more
direct I/O to the database has failed to improve anything; the result is
neither barely noticeable, or a major performance drop. This is
particularly futile if you're doing your research on Linux/ext3, where even
if your code works delivers a speed up no one will trust it enough to ever
merge and deploy it, due to the generally poor quality of that area of the
kernel so far.
This particular area is magnetic for drawing developer attention as it
seems like there's a big win just under the surface if things were improved
a bit. There isn't. On operating systems like Solaris where it's possible
to prototype here by use mounting options to silently covert parts of the
database to direct I/O, experiments in that area have all been
disappointing. One of the presentations from Jignesh Shah at Sun covered
his experiments in this area, can't seem to find it at the moment but I
remember the results were not positive in any way.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.us