Re: per table random-page-cost?

Поиск
Список
Период
Сортировка
От Stefan Moeding
Тема Re: per table random-page-cost?
Дата
Msg-id 8763a58h61.fsf@esprit.moeding.net
обсуждение исходный текст
Ответ на Re: per table random-page-cost?  (Josh Berkus <josh@agliodbs.com>)
Список 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 по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: misleading comments in pgbench
Следующее
От: Magnus Hagander
Дата:
Сообщение: Parsing config files in a directory