From: Tom Lane <tgl@sss.pgh.pa.us>
To: HSIEN-WEN CHU <hsienwen.chu@googlemail.com>
Cc: pgsql-hackers@postgresql.org
Subject: Re: VX_CONCURRENT flag on vxfs( 5.1 or later) for performance for postgresql?
Date: Thu, 28 Apr 2011 09:25:33 -0400
Message-ID: <25785.1303997133@sss.pgh.pa.us> (raw)
In-Reply-To: <BANLkTinBLhq8mYyeVupWz5J02OWfbTK_nA@mail.gmail.com>
References: <BANLkTinBLhq8mYyeVupWz5J02OWfbTK_nA@mail.gmail.com>
HSIEN-WEN CHU <hsienwen.chu@googlemail.com> writes:
> 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,
Presumably, if whatever behavior this invokes were an unalloyed good,
they'd have just made it the default. The existence of a flag makes
me suppose that there are some clear application-visible downsides.
What are they?
BTW, please do not cross-post the same question to three different lists.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, hsienwen.chu@googlemail.com, pgsql-hackers@postgresql.org
Subject: Re: VX_CONCURRENT flag on vxfs( 5.1 or later) for performance for postgresql?
In-Reply-To: <25785.1303997133@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox