Skip site navigation (1) Skip section navigation (2)

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

From: HSIEN-WEN CHU <hsienwen(dot)chu(at)googlemail(dot)com>
To: pgsql-performance(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: VX_CONCURRENT flag on vxfs( 5.1 or later) for performance for postgresql?
Date: 2011-04-28 03:33:44
Message-ID: BANLkTinBLhq8mYyeVupWz5J02OWfbTK_nA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-novicepgsql-performance
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

Responses

pgsql-novice by date

Next:From: Glus XofDate: 2011-04-28 10:25:54
Subject: Pg Sessions
Previous:From: John PayneDate: 2011-04-28 03:03:02
Subject: failure and silence of SQL commands

pgsql-performance by date

Next:From: Sethu PrasadDate: 2011-04-28 08:03:39
Subject: Re: Performance
Previous:From: Greg SmithDate: 2011-04-28 02:18:37
Subject: Re: index usage on queries on inherited tables

pgsql-hackers by date

Next:From: Noah MischDate: 2011-04-28 03:41:30
Subject: Re: XML with invalid chars
Previous:From: Andrew DunstanDate: 2011-04-28 03:22:37
Subject: Re: XML with invalid chars

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group