View Single Post

   
  #1 (permalink)  
Old 04-17-2008, 11:22 PM
Neil Conway
 
Posts: n/a
Default Re: O_DIRECT for WAL writes

ITAGAKI Takahiro wrote:
> The patch adds a new choice "open_direct" to wal_sync_method.
> It uses O_DIRECT flags for WAL writes, like O_SYNC.


Have you looked at what the performance difference of this option is?
For example, these benchmark results seem to indicate that an older
version of the patch is not a performance win, at least for OSDL's workload:

http://www.mail-archive.com/pgsql-pa.../msg07186.html

Is this data still applicable to the revised patch?

-Neil

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Reply With Quote