Doesn't seem to be the case. This table has been around for a while and should have been auto-analyzed by now. But anyway:
db=> analyze lead; ANALYZE db=> explain select * from lead where email = 'f...@blah.com'; QUERY PLAN --------------------------------------------------------------------------- Seq Scan on lead (cost=10000000000.00..10000319666.99 rows=1 width=5208) Filter: (email = 'f...@blah.com'::text) (2 rows) On Fri, Apr 12, 2013 at 1:13 AM, John R Pierce <pie...@hogranch.com> wrote: > On 4/12/2013 1:03 AM, Yang Zhang wrote: >> >> db=> explain select * from lead where email = 'blah'; >> QUERY PLAN >> ------------------------------------------------------------ >> Seq Scan on lead (cost=0.00..319599.38 rows=1 width=5108) >> Filter: (email = 'blah'::text) > > > > try EXPLAIN ANALYZE ..... its more useful. > > my guess is, there's no statistics on this table, and doing an ANALYZE lead; > would rectify this. > > > > -- > john r pierce 37N 122W > somewhere on the middle of the left coast > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Yang Zhang http://yz.mit.edu/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general