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
|
| Список | pgsql-hackers |
On Tue, Apr 26, 2011 at 1:10 PM, Alexander Korotkov <aekorotkov@gmail.com> wrote:
----
With best regards,
Alexander Korotkov.
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 по дате отправления: