Re: Postmaster won't -HUP
Jerry Lynde <jlynde@diligence.com>
From: Jerry Lynde <jlynde@diligence.com>
To: pgsql-general@postgresql.org
Date: 2000-06-01T20:09:47Z
Lists: pgsql-general
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