Re: Batch update of indexes on data loading

Itagaki-san,

> Alvaro Herrera <alvherre@commandprompt.com> 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.

Thanks so much for doing this.  For one thing, it will vastly improve 
PostgreSQL's ability to run industry-standard benchmarks.  As well as making 
dump/reload much less painful.

> I heard it is used in Falcon storage engine in MySQL, so it seems to be
> not so unrealistic approach.

I don't think we want to copy any spec from Falcon ... it's a year (or more) 
behind schedule.

-- 
Josh Berkus
PostgreSQL @ Sun
San Francisco