[HACKERS] 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

Re: [HACKERS] PostgreSQL and HugePage

2010-10-24 Thread Hsien-Wen Chu
as my known, FreeBSD implements this feature called superpage, it's similar with Solaris, so is it enabled in default? or any default parameter need to be set? Many thank Hsien-Wen On Wed, Oct 20, 2010 at 10:10 PM, Tom Lane wrote: > Robert Haas writes: > > On Tue, Oct 19, 2010 at 11:30 PM, d

[HACKERS] PostgreSQL and HugePage

2010-10-19 Thread Hsien-Wen Chu
Dear All I want to use hugepage function on Linux platform, my question is if PostgreSQL supports hugepage in default, if not, what's the code need to be modified? Thank you for your greate support Hsien-Wen