Tom Lane escribió:

> In the long run, for queries inserting many rows it might be interesting
> to accumulate all the entries intended for a btree index and sort them
> before inserting.  Not sure about possible downsides of that.

Yeah, in the long run we need a more flexible approach towards index
insertion.  I doubt we want to know _all_ the entries beforehand; that
would probably involve disk-spilling, etc.  Perhaps accumulate a
reasonable number (using up to work_mem?) and insert those in batches.

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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org/

Reply via email to