Re: Batch update of indexes on data loading

ITAGAKI Takahiro wrote:

> The basic concept is spooling new coming data, and merge the spool and
> the existing indexes into a new index at the end of data loading. It is 
> 5-10 times faster than index insertion per-row, that is the way in 8.3.

Please see

http://thread.gmane.org/gmane.comp.db.postgresql.general/102370/focus=102901

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.