Bruce Momjian <pgman@candle.pha.pa.us> wrote: > I looked this over and I am unsure what this does for us that isn't > already accomplished using the wal_sync_method settings. See xlog.c for > a description of O_DIRECT and when it is used.
I proposed it to supplement the cache control. There are some OSes that supports posix_fadvise but not O_DIRECT, for example, NetBSD 4.0 (http://www.netbsd.org/Changes/changes-4.0.html). --- ITAGAKI Takahiro NTT Cyber Space Laboratories ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match