Re: WAL and O_DIRECT - Mailing list pgsql-admin

From Tom Lane
Subject Re: WAL and O_DIRECT
Date
Msg-id 20588.1431616292@sss.pgh.pa.us
Whole thread Raw
In response to WAL and O_DIRECT  (Ravi Krishna <s.ravikrishna@aim.com>)
Responses Re: WAL and O_DIRECT
List pgsql-admin
Ravi Krishna <s.ravikrishna@aim.com> writes:
> Why is O_DIRECT not used, despite the documentation mentioning otherwise?

You've not shown us all your settings, but this comment in xlog.c might
explain it:

     * Optimize writes by bypassing kernel cache with O_DIRECT when using
     * O_SYNC/O_FSYNC and O_DSYNC.  But only if archiving and streaming are
     * disabled, otherwise the archive command or walsender process will read
     * the WAL soon after writing it, which is guaranteed to cause a physical
     * read if we bypassed the kernel cache. We also skip the
     * posix_fadvise(POSIX_FADV_DONTNEED) call in XLogFileClose() for the same
     * reason.

            regards, tom lane


pgsql-admin by date:

Previous
From: Ravi Krishna
Date:
Subject: WAL and O_DIRECT
Next
From: Ravi Krishna
Date:
Subject: Re: WAL and O_DIRECT