Re: Postmaster won't -HUP - Mailing list pgsql-general

At 12:11 PM 6/1/00 -0500, Ed Loehr wrote:
>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?
>
>Regards,
>Ed Loehr


They are all indexed, the DOB index is actually  DOBYear DOBDay and
DOBMonth and all 5 fields are indexed