Excerpts from Heikki Linnakangas's message of vie nov 12 11:01:39 -0300 2010:
> It took me a while to understand what Greg meant as well. You can't scan
> a B-tree index in *physical order*, You have to first descend to the
> leftmost leaf, and follow the right pointers from there until you reach
> the rightmost leaf. That is a lot slower than seqscanning a file in
> physical order.
Oh, that makes more sense. I'm not sure that can be supported sanely
(i.e. not locking the whole index)
--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support