Re: [PERFORM] VX_CONCURRENT flag on vxfs( 5.1 or later) for performance for postgresql?

2011-05-02 Thread Hsien-Wen Chu
Greg Smith wrote: > On 04/30/2011 12:24 AM, Hsien-Wen Chu wrote: >> I'm little bit confuse why it is not safe. and my question is following. >> >> for database application, we need to avoid double cache, PostgreSQL >> shared_buffer will cache the data, so we do no

[PERFORM] VX_CONCURRENT flag on vxfs( 5.1 or later) for performance for postgresql?

2011-04-27 Thread HSIEN-WEN CHU
Dear all When database files are on a VxFS filesystem, performance can be significantly improved by setting the VX_CONCURRENT cache advisory on the file according to vxfs document, my question is that have any tested by this? #include ioctl(fd, VX_SETCACHE, VX_CONCURRENT); Regards HSIEN WEN