> - Oracle is content with data read from an index if that is all that's
> needed. Indeed, I only need bar and baz and those are in the index.
> The benefits of not having to seek the scattered rows from the data
> table saves 35000 back and forth head movements / seeks.
Postgres can't use the data from its indices, because of the MVCC mechanism.
Maybe you should try CLUSTERing your table to improve performance???
Chris
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
