Re: another "EXPLAIN -- NO INDEX?" question - Mailing list pgsql-general

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@serensoft.com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!