Re: Prefetch children

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: Prefetch children
Дата
Msg-id 1095664254.28879.476.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Prefetch children  (Ioannis Theoharis <theohari@ics.forth.gr>)
Ответы Re: Prefetch children  (Ioannis Theoharis <theohari@ics.forth.gr>)
Список pgsql-general
On Sat, 2004-09-18 at 07:42, Ioannis Theoharis wrote:
> I'd like to ask you,
> if postgres prefetch child instances in memory ,
> whenever a parent table is sequentially scanned,
> in order to have them in there
> for the possibility the next query to ask for them.

I'm not sure exactly what you're asking (what do you mean by "child
instances?"), but in any case, PostgreSQL doesn't do any prefetching
("readahead") -- we rely on the kernel to do that if and when it's
appropriate.

-Neil



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: NULL/0
Следующее
От: Paramveer.Singh@trilogy.com
Дата:
Сообщение: Re: order of row processing affects updates