Postgres Pro
Downloads
Home   >   mailing lists

VX_CONCURRENT flag on vxfs( 5.1 or later) for performance for postgresql? - Mailing list pgsql-performance

From HSIEN-WEN CHU
Subject VX_CONCURRENT flag on vxfs( 5.1 or later) for performance for postgresql?
Date
Msg-id BANLkTinBLhq8mYyeVupWz5J02OWfbTK_nA@mail.gmail.com
Whole thread Raw
Responses Re: VX_CONCURRENT flag on vxfs( 5.1 or later) for performance for postgresql?
List pgsql-performance
Tree view 
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 <sys/fs/vx_ioctl.h>
ioctl(fd, VX_SETCACHE, VX_CONCURRENT);


Regards

HSIEN WEN

pgsql-performance by date:

Previous
From: Sok Ann Yap
Date:
Subject: Re: reducing random_page_cost from 4 to 2 to force index scan
Next
From: Sok Ann Yap
Date:
Subject: Re: reducing random_page_cost from 4 to 2 to force index scan