At 01:21 PM 6/1/00 -0400, Tom Lane wrote:
>Ed Loehr <eloehr(at)austin(dot)rr(dot)com> writes:
> > Jerry Lynde wrote:
> >>
> >> As for the query I'm running, it was simply select * from bigtable (about
> >> 2-300k lines) where
> >> firstname=<obscure fname> and
> >> lastname=<obscure lname> and
> >> DOB=<the exact DOB for the above named individual>
>
> > What indices do you have on those fields?
>
>And is it using them --- ie, what does EXPLAIN say about the query?
>
> regards, tom lane
It started indexing on DOBMonth until I did a VACUUM ANALYZE, after which
it uses the lastname index