Re: WIP: Fast GiST index build - Mailing list pgsql-hackers

From Alexander Korotkov
Subject Re: WIP: Fast GiST index build
Date
Msg-id CAPpHfdsMMTHjMW_AFn4-seqspQacbmHTssnZ_JGQ-14bHKTwvg@mail.gmail.com
Whole thread Raw
In response to Re: WIP: Fast GiST index build  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: WIP: Fast GiST index build
List 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.

pgsql-hackers by date:

Previous
From: Radosław Smogura
Date:
Subject: Re: Patch Review: Bugfix for XPATH() if text or attribute nodes are selected
Next
From: Alexander Korotkov
Date:
Subject: Re: WIP: Fast GiST index build