bulk loading of bplus index tree - Mailing list pgsql-general

From Surabhi Ahuja
Subject bulk loading of bplus index tree
Date
Msg-id CE5C48E227F8ED4990FAC4332100ADC621B53B@EVS.iiitb.ac.in
Whole thread Raw
Responses Re: bulk loading of bplus index tree
List pgsql-general

I have heard about "bulk loading algorithm" for indexes..
for eg. if u have values like 1, 2,3,4,5, etc...till a very large number.
in case of simple mechanism of indexing, the values will be inserted one by one for eg..1 then 2 and so on
however in bulk loading ..the mechanism of building the index (bplus)tree is quite diffreent and very fast ezpecially if u consider a very large number of values.

My question is : is this algorith implemented by postgreSQL. If yes please tell in what cases can i make use of it.

Thank You
Regards
Surabhi Ahuja

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: enable_sort optimization problem
Next
From: Russell Smith
Date:
Subject: Re: bulk loading of bplus index tree