On Fri, Aug 12, 2011 at 4:03 PM, Heikki Linnakangas <heikki.linnakan...@enterprisedb.com> wrote: > On 11.08.2011 23:06, Robert Haas wrote: >> >> Comments, testing, review appreciated... > > I would've expected this to use an index-only scan: > > postgres=# CREATE TABLE foo AS SELECT generate_series(1,100000) AS id;
Ugh. I think there's something wrong with this test: + if (index->amcanreturn && !index->predOK && !index->indexprs) I think that should probably say something like (ind->indpred == NIL || ind->predOK). -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers