> > 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

pgsql-hackers by date

Next:	From: Zeugswetter Andreas SB SD	Date: 2001-10-01 12:33:43
	Subject: Re: Problem on AIX with current
Previous:	From: Stefan Rindeskar	Date: 2001-10-01 12:12:29
	Subject: Re: Moving CVS files around?