Re: Warm-up cache may have its virtue

Поиск
Список
Период
Сортировка
От Qingqing Zhou
Тема Re: Warm-up cache may have its virtue
Дата
Msg-id dqbpg6$qnq$1@news.hub.org
обсуждение исходный текст
Ответ на Warm-up cache may have its virtue  (Qingqing Zhou <zhouqq@cs.toronto.edu>)
Ответы Re: Warm-up cache may have its virtue  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-hackers
"Qingqing Zhou" <zhouqq@cs.toronto.edu> wrote
>
> I wonder if we should really implement file-system-cache-warmup strategy
> which we have discussed before. There are two natural good places to do
> this:
>
> (1) sequentail scan
> (2) bitmap index scan
>

For the sake of memory, there is a third place a warm-up cache or pre-read 
is beneficial (OS won't help us):
(3) xlog recovery

Regards,
Qingqing




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

Предыдущее
От: mark@mark.mielke.cc
Дата:
Сообщение: Re: Surrogate keys (Was: enums)
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Surrogate keys (Was: enums)