Postgres Pro
Downloads
Home   >   mailing lists

Re: Batch update of indexes on data loading - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Batch update of indexes on data loading
Date
Msg-id 20080221142800.GB7012@alvh.no-ip.org
Whole thread Raw
In response to Batch update of indexes on data loading  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Responses Re: Batch update of indexes on data loading
List pgsql-hackers
Tree view 
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.

pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Getting available options
Next
From: Dave Cramer
Date:
Subject: insufficient data left in message