Re: per table random-page-cost? - Mailing list pgsql-hackers

From Stefan Moeding
Subject Re: per table random-page-cost?
Date
Msg-id 8763a58h61.fsf@esprit.moeding.net
Whole thread Raw
In response to Re: per table random-page-cost?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Hi!

Josh Berkus writes:

> Now, if we had an OS which could be convinced to handle caching
> differently for different physical devices, then I could see wanting
> this setting to be per-tablespace.  For example, it would make a lot of
> sense not to FS-cache any data which is on a ramdisk or superfast SSD
> array.  The same with archive data which you expected to be slow and
> infrequently accessed on a NAS device.  If your OS can do that, while
> caching data from other sources, then it would make sense.
>
> However, I don't know any current OS which allows for this.  Does anyone
> else?

Isn't bypassing the buffer cache exactly what direct I/O is about?
Solaris UFS has a "forcedirectio" mount option, AIX JFS2 calls it "dio"
and Veritas VxFS uses the "convosync=direct" option to disable caching
the content of the filesystem.

-- 
Stefan


pgsql-hackers by date:

Previous
From: Jeff Janes
Date:
Subject: misleading comments in pgbench
Next
From: Magnus Hagander
Date:
Subject: Parsing config files in a directory