From: | Jerry Lynde <jlynde(at)diligence(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Postmaster won't -HUP |
Date: | 2000-06-01 21:29:02 |
Message-ID: | 4.2.0.58.20000601152816.0098d6a0@mail.diligence.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
At 05:19 PM 6/1/00 -0400, Joseph Shraibman wrote:
>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?
Sorry for being less than explicit. There are 5 separate indices, one per
field.
Jerry Lynde
IT - Invocation/Evocation, Banishing, et al.
"In E-commerce, the E stands for Evil."
Due Diligence Inc.
http://www.diligence.com
Phone: (406) 728-0001 x232
Fax: (406) 728-0006
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-06-01 21:42:07 | Re: btree index and max() |
Previous Message | Joseph Shraibman | 2000-06-01 21:19:43 | Re: Postmaster won't -HUP |