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/
