On Wed, Jul 13, 2011 at 12:40 PM, Alexander Korotkov
<aekorotkov@gmail.com> wrote:
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.
Yes, it seems to be possible.
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.