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>
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= > fname> and
> > >                                                 lastname= > lname> and
> > >                                                 DOB= > 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 по дате отправления
От: leonbloy@sinectis.com.ar
Дата:
Сообщение: Re: Q: Truncated output
От: Jerry Lynde
Дата:
Сообщение: Re: Postmaster won't -HUP
FAQ