| From: | Joseph Shraibman <jks(at)selectacast(dot)net> |
|---|---|
| To: | Jerry Lynde <jlynde(at)diligence(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Postmaster won't -HUP |
| Date: | 2000-06-01 21:19:43 |
| Message-ID: | 3936D36F.D5035FE9@selectacast.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Jerry Lynde wrote:
>
> 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
Do you have 5 indexes or do you have an index that spans more than one
field?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jerry Lynde | 2000-06-01 21:29:02 | Re: Postmaster won't -HUP |
| Previous Message | leonbloy | 2000-06-01 21:10:45 | Re: Q: Truncated output |