Postgres Pro
Downloads
Home   >   mailing lists

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

From Ed Loehr
Subject Re: Postmaster won't -HUP
Date
Msg-id 39369956.9981F79E@austin.rr.com
Whole thread Raw
In response to Postmaster won't -HUP  (Jerry Lynde <jlynde@diligence.com>)
Responses Re: Postmaster won't -HUP  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Postmaster won't -HUP  (Jerry Lynde <jlynde@diligence.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Jerry Lynde
Date:
Subject: Re: Postmaster won't -HUP
Next
From: Ron Peterson
Date:
Subject: Re: ALTERING A TABLE