Re: WIP: Fast GiST index build
| От | Alexander Korotkov |
|---|---|
| Тема | Re: WIP: Fast GiST index build |
| Дата | |
| Msg-id | CAPpHfdsOwK+Tbi2oDnKtZ_C+rdzQXfLPuT9CzGFvy+X8Nor+cQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: WIP: Fast GiST index build (Alexander Korotkov <aekorotkov@gmail.com>) |
| Список | pgsql-hackers |
On Wed, Jul 13, 2011 at 12:40 PM, Alexander Korotkov <aekorotkov@gmail.com> wrote:
On Wed, Jul 13, 2011 at 12:33 PM, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> wrote:Yes, it seems to be possible.Is it possible to switch to the new buffering method in the middle of an index build? We could use the plain insertion method until the index grows to a certain size (effective_cache_size?), and switch to the buffering method after that.
It also gives possibility to get estimate of varlena size by real data before start of buffering method using.
It also would be great to somehow detect case of ordered data when regular index build performs well.
I think this case can be detected by the situation when most part of index tuples are inserting into few leaf pages which was recently used.
------
With best regards,
Alexander Korotkov.
With best regards,
Alexander Korotkov.
В списке pgsql-hackers по дате отправления: