On Wed, Jul 13, 2011 at 12:40 PM, Alexander Korotkov <aekorot...@gmail.com>wrote:
> On Wed, Jul 13, 2011 at 12:33 PM, Heikki Linnakangas < > heikki.linnakan...@enterprisedb.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.
