> > The O_DIRECT flag has been added to open(2) and fcntl(2). Specifying this > > flag for open files will attempt to minimize the cache effects of reading > > and writing. > > I wonder if using this for WAL would be good.
Not before the code is not optimized to write more than the current 8k to the WAL at a time. (The killer currently are larger transactions that produce approx more than 64k WAL, (try the open_datasync setting with "copy from")) Andreas ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
