Re: GSoC 2011: Fast GiST index build

Поиск
Список
Период
Сортировка
От Alexander Korotkov
Тема Re: GSoC 2011: Fast GiST index build
Дата
Msg-id BANLkTint6Vc-=uPRR9bSa4uviCHKHL14Hw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: GSoC 2011: Fast GiST index build  (Alexander Korotkov <aekorotkov@gmail.com>)
Ответы Re: GSoC 2011: Fast GiST index build  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список pgsql-hackers
On Tue, Apr 26, 2011 at 1:10 PM, Alexander Korotkov <aekorotkov@gmail.com> wrote:
Since algorithm is focused to reduce I/O, we should expect best acceleration in the case when index doesn't fitting to memory. Size of buffers is comparable to size of whole index. It means that if we can hold buffers in memory then we mostly can hold whole index in memory. That's why I think we should have simple on-disk buffers management for first representative benchmark.
Since we need to free all buffers after index built, I believe that buffers should be stored separately. If not, index become bloat immediatly after creation. We probably need to create a temporary relation to store buffers in it. If my thought is right, then is there any example of using temporary relation?
 
----
With best regards,
Alexander Korotkov.

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

Предыдущее
От: Shiv
Дата:
Сообщение: Introduction
Следующее
От: Markus Wanner
Дата:
Сообщение: Re: Proposal - asynchronous functions