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