Re: indexes not being used! - Mailing list pgsql-admin

From Tom Lane
Subject Re: indexes not being used!
Date
Msg-id 14197.1048269769@sss.pgh.pa.us
Whole thread Raw
In response to Re: indexes not being used!  (Jodi Kanter <jkanter@virginia.edu>)
Responses Re: indexes not being used!  (Joe Conway <mail@joeconway.com>)
List pgsql-admin
Jodi Kanter <jkanter@virginia.edu> writes:
> I apologize if this is the wrong list. I have posted explain analyzes below.

Given the small size of the tables, I think the planner is doing the
right thing not to use indexes.  Seqscans are probably less I/O until
the tables get a lot bigger.

The bitwise-and tests are not indexable anyway... you might want to
reconsider that data representation, if you were hoping that the bit
conditions would be useful for indexing.

            regards, tom lane

pgsql-admin by date:

Previous
From: Jie Liang
Date:
Subject: perl 5.6.1 and PostgreSQL7.3.2
Next
From: Joe Conway
Date:
Subject: Re: indexes not being used!