Re: Postmaster won't -HUP
От | Joseph Shraibman |
---|---|
Тема | Re: Postmaster won't -HUP |
Дата | |
Msg-id | 3936D36F.D5035FE9@selectacast.net обсуждение исходный текст |
Ответ на | Postmaster won't -HUP (Jerry Lynde <jlynde@diligence.com>) |
Ответы |
Re: Postmaster won't -HUP
|
Список | 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?
В списке pgsql-general по дате отправления: