Re: [HACKERS] Tuplesort merge pre-reading

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] Tuplesort merge pre-reading
Дата
Msg-id 22681.1492145840@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Tuplesort merge pre-reading  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
I wrote:
> Heikki Linnakangas <hlinnaka@iki.fi> writes:
>> I'm talking about the code that reads a bunch of from each tape, loading 
>> them into the memtuples array. That code was added by Tom Lane, back in 
>> 1999:
>> So apparently there was a benefit back then, but is it still worthwhile? 

> I'm fairly sure that the point was exactly what it said, ie improve
> locality of access within the temp file by sequentially reading as many
> tuples in a row as we could, rather than grabbing one here and one there.

[ blink... ]  Somehow, my mail reader popped up a message from 2016
as current, and I spent some time researching and answering it without
noticing the message date.

Never mind, nothing to see here ...
        regards, tom lane



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Tuplesort merge pre-reading
Следующее
От: Amit Langote
Дата:
Сообщение: Re: [HACKERS] pg_dump emits ALTER TABLE ONLY partitioned_table