Re: Caching by Postgres

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Caching by Postgres
Дата
Msg-id 21392.1124860042@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Caching by Postgres  (Gavin Sherry <swm@alcove.com.au>)
Ответы Re: Caching by Postgres  (Gavin Sherry <swm@alcove.com.au>)
Список pgsql-performance
Gavin Sherry <swm@alcove.com.au> writes:
> A filesystem could, in theory, help us by providing an API which allows us
> to tell the file system either: the way we'd like it to read ahead, the
> fact that we don't want it to read ahead or the way we'd like it to cache
> (or not cache) data. The thing is, most OSes provide interfaces to do this
> already and we make only little use of them (I'm think of
> madv_sequential(), madv_random(), POSIX fadvise(), the various flags to
> open() which AIX, HPUX, Solaris provide).

Yeah ... the main reason we've not spent too much time on that sort of
stuff is that *it's not portable*.  And with all due respect to Hans,
special tweaks for one filesystem are even less interesting than special
tweaks for one OS.

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Jeffrey W. Baker"
Дата:
Сообщение: Re: Read/Write block sizes
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Read/Write block sizes