| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-novice pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Noah Misch | 2011-04-28 03:41:30 | Re: XML with invalid chars |
| Previous Message | Andrew Dunstan | 2011-04-28 03:22:37 | Re: XML with invalid chars |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Glus Xof | 2011-04-28 10:25:54 | Pg Sessions |
| Previous Message | John Payne | 2011-04-28 03:03:02 | failure and silence of SQL commands |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sethu Prasad | 2011-04-28 08:03:39 | Re: Performance |
| Previous Message | Greg Smith | 2011-04-28 02:18:37 | Re: index usage on queries on inherited tables |