At 05:58 PM 6/1/00 -0400, you wrote:
Jerry Lynde <[EMAIL PROTECTED]> writes:
>>>> 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 tha
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 * f
At 01:21 PM 6/1/00 -0400, Tom Lane wrote:
>Ed Loehr <[EMAIL PROTECTED]> writes:
> > Jerry Lynde wrote:
> >>
> >> As for the query I'm running, it was simply select * from bigtable (about
> >> 2-300k lines) where
> >> firstname= and
> &
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
> >
chine has two 500mHz processors with 256 MB ram. I have a hard time
believing that one small query can bring that machine to its knees, but it
has, twice. The queries were run through a hard coded php front end (for
testing purposes). Any insight on these two problems would be appreciated
greatl
