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 would be great to somehow detect case of ordered data when regular index build performs well.