ow wrote:
> 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