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

Поиск
Список
Период
Сортировка
От Christopher Browne
Тема Re: Anything to be gained from a 'Postgres Filesystem'?
Дата
Msg-id m3r7n9t5hr.fsf@knuth.knuth.cbbrowne.com
обсуждение исходный текст
Ответ на Re: Anything to be gained from a 'Postgres Filesystem'?  ("Leeuw van der, Tim" <tim.leeuwvander@nl.unisys.com>)
Список pgsql-performance
After a long battle with technology, simon@2ndquadrant.com (Simon Riggs), an earthling, wrote:
> 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.

We're not talking about the same cache.

ARC does these exact things for _shared memory_ cache, and is the
obvious inspiration.

But it does more or less nothing about the way OS file buffer cache is
managed, and the handling of _that_ would be the point of modifying OS
filesystem semantics.
--
select 'cbbrowne' || '@' || 'linuxfinances.info';
http://www3.sympatico.ca/cbbrowne/oses.html
Have you ever considered beating yourself with a cluestick?

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

Предыдущее
От: Martin Foster
Дата:
Сообщение: Re: Restricting Postgres
Следующее
От: Neil Conway
Дата:
Сообщение: Re: Anything to be gained from a 'Postgres Filesystem'?