On Tue, Jul 17, 2012 at 1:24 PM, Jeff Janes <jeff.ja...@gmail.com> wrote: > Also, while indexes are not formally kept in logical order, but they > do tend to be biased in that direction in most cases. I've found that > even if you are only inserting one row for every 4 or 5 leaf pages, > you still get substantial improvement by doing so in sorted order.
Yep, I do the same. Whenever I have to perform massive updates, I sort them. Although "massive" for me is nowhere near what "massive" for the OP is. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
