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

Поиск
Список
Период
Сортировка
От HSIEN-WEN CHU
Тема VX_CONCURRENT flag on vxfs( 5.1 or later) for performance for postgresql?
Дата
Msg-id BANLkTinBLhq8mYyeVupWz5J02OWfbTK_nA@mail.gmail.com
обсуждение исходный текст
Ответы Re: VX_CONCURRENT flag on vxfs( 5.1 or later) for performance for postgresql?  (Greg Smith <greg@2ndQuadrant.com>)
Список 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Sok Ann Yap
Дата:
Сообщение: Re: reducing random_page_cost from 4 to 2 to force index scan
Следующее
От: Sok Ann Yap
Дата:
Сообщение: Re: reducing random_page_cost from 4 to 2 to force index scan