| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | HSIEN-WEN CHU <hsienwen(dot)chu(at)googlemail(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: VX_CONCURRENT flag on vxfs( 5.1 or later) for performance for postgresql? |
| Date: | 2011-04-28 13:25:33 |
| Message-ID: | 25785.1303997133@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-novice pgsql-performance |
HSIEN-WEN CHU <hsienwen(dot)chu(at)googlemail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shiv | 2011-04-28 13:34:32 | Re: improvements to pgtune |
| Previous Message | Marko Kreen | 2011-04-28 13:21:16 | Re: Extension Packaging |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2011-04-28 13:28:58 | Re: failure and silence of SQL commands |
| Previous Message | Francisco Leovey | 2011-04-28 13:14:45 | PgAdmin no longer works on a "clean install" XP SP2 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Janes | 2011-04-28 15:56:10 | Re: reducing random_page_cost from 4 to 2 to force index scan |
| Previous Message | Heikki Linnakangas | 2011-04-28 12:33:06 | Re: Order of tables |