Re: Anything to be gained from a 'Postgres Filesystem'?

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Anything to be gained from a 'Postgres Filesystem'?
Дата
Msg-id 1099595027.4320.663.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: Anything to be gained from a 'Postgres Filesystem'?  (Chris Browne <cbbrowne@acm.org>)
Ответы Re: Anything to be gained from a 'Postgres Filesystem'?
Список pgsql-performance
On Thu, 2004-11-04 at 15:47, Chris Browne wrote:

> Another thing that would be valuable would be to have some way to say:
>
>   "Read this data; don't bother throwing other data out of the cache
>    to stuff this in."
>
> Something like a "read_uncached()" call...
>
> That would mean that a seq scan or a vacuum wouldn't force useful data
> out of cache.

ARC does almost exactly those two things in 8.0.

Seq scans do get put in cache, but in a way that means they don't spoil
the main bulk of the cache.

--
Best Regards, Simon Riggs


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

Предыдущее
От: "Matt Clark"
Дата:
Сообщение: Re: Restricting Postgres
Следующее
От: "Steinar H. Gunderson"
Дата:
Сообщение: Re: Anything to be gained from a 'Postgres Filesystem'?