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 <alvhe...@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to