Itagaki-san, > Alvaro Herrera <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate