Jerry Lynde <[EMAIL PROTECTED]> writes:
> Thanks for the tip. I might indeed take that approach in the future,
> however that's not really the problem I'm trying to tackle right now.
> Indexing by Last Name is fine with me, currently. What's not working for me
> is the part where the dual
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 that spans more than one
>> field?
> Sorry for
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 that spans more than one
>> field?
> Sorry for being less than explicit. There are 5 sep
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
> > > >
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
> > >
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
> >> lastname= and
> >> DOB=
>
> > What indices do you have on th
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
> >
Jerry Lynde wrote:
>
> Hello out there,
>
> I'm having a problem with a production server. Actually, there are two
> problems. The semi-trivial problem is that Postgres won't die using the
> service mechanism. As root, I "service postgres stop" and then "service
> postgres start" after a
Jerry Lynde wrote:
>
> I'm having a problem with a production server. Actually, there are two
> problems. The semi-trivial problem is that Postgres won't die using the
> service mechanism. As root, I "service postgres stop" and then "service
> postgres start" after a reasonable wait. The
In version 7.0 postgres waits for all clients to close their connections
before exiting. Before it just quit.
Jerry Lynde wrote:
>
> Hello out there,
>
> I'm having a problem with a production server. Actually, there are two
> problems. The semi-trivial problem is that Postgres won't d
10 matches
Mail list logo
