Re: WIP: Fast GiST index build

Alexander Korotkov <aekorotkov@gmail.com>

From: Alexander Korotkov <aekorotkov@gmail.com>
To: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2011-07-13T08:40:20Z
Lists: pgsql-hackers
Hi!

On Wed, Jul 13, 2011 at 12:33 PM, Heikki Linnakangas <
heikki.linnakangas@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 would be great to somehow detect case
of ordered data when regular index build performs well.

------
With best regards,
Alexander Korotkov.