On Thu, Aug 11, 2005 at 09:02:03PM -0400, Tom Lane wrote:
> I am sure I will get some pushback if I propose reverting the O_DIRECT
> patch, so could you try to get some more-specific evidence? Like pull
> the CVS tree from just before and just after this patch and compare
> performance?
Quoth the open(2) manpage:
O_DIRECT Try to minimize cache effects of the I/O to and from this file. In general
thiswill degrade performance, but it is useful in special situations, such as when applications do
their own caching. File I/O is done directly to/from user space buffers. The I/O is synchronous,
i.e.,at the comple- tion of the read(2) or write(2) system call, data is guaran- teed to have
beentransferred.
In light of this, may I ask whether it makes sense to compare the
performance of two runs with similar shared_buffer settings? With
O_DIRECT, I understand from this manpage that the OS is going to do
little or no page caching, so shared_buffers should be increased to
account for this fact.
Am I missing something?
--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"Hay que recordar que la existencia en el cosmos, y particularmente la
elaboración de civilizaciones dentre de él no son, por desgracia,
nada idílicas" (Ijon Tichy)