"stormb...@gmail.com" <stormb...@gmail.com> wrote: > [ Seq Scan is used on empty relation, rather than Index Scan ]
> This is not the expected result. [ ... ] it is still using > sequential scan rather than what would be expected: Index Scan This is not a bug. If statistics indicate that all rows can be accessed with one page access (to the heap) why should it use an index? -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
