My impression was that the index "I_bca" covers the query, hence there should not be a need to go to the table itself. Why would it?
Postgres always has to go to the table. The ability to read data directly from indexes (ala other RDBMSs) has been discussed, but not implemented. IIRC it's a hard problem due to the way Postgres does MVCC. Check the archives.
explain analyze vs explain. Normally, would've used "explain analyze" but in this case it's taking way too long so I used "explain".
I can understand that, but most people will ask for explain analyze anyway ;-)
Joe
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
