Hi, in case that one has a table R(att0 int4, att1 int4), an index on att1 and a query selecting only att1 whith a range condition over att1, then the optimal access path for a rdbms would be "INDEX ONLY SCAN", which means scan only the index, and not the relation (all the needed information exists in index, because the select clause has only the att1 attribute). This access path is selected in this case by Oracle. As far as i can see, postgresql select a simple "INDEX SCAN using index" on table. Is there any tuning that one has to do, in order to make postgresql's optimizer to select "INDEX ONLY SCAN" ? Or postgresql doesn't support this feature at all? thanks. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
