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

Ed Loehr <eloehr@austin.rr.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