Re: another "EXPLAIN -- NO INDEX?" question

On Sun, Feb 10, 2002 at 11:29:57AM -0500, Tom Lane wrote:
> Try 7.2, and don't forget to VACUUM ANALYZE after you've loaded the
> data.

i'm stuck with 7.1 for now, and i do the vacuum analyze
nightly... any other ideas?

---------

create index hits_by_server on hits(server);

hits=# explain
hits-# select * from hits where (server = 1 or server = 3);

NOTICE: QUERY PLAN:
Seq Scan on hits (cost=0.00..8537.01 rows=20205 width=90)
EXPLAIN

hits=# select count(*) from hits;
count
--------
266611
(1 row)

hits=# select count(*) from hits where (server=1 or server=3);
count
-------
3678
(1 row)

--
Legalize Liberty.

will(at)serensoft(dot)com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!