Re: Lack of use of indexes - Mailing list pgsql-general

From scott.marlowe
Subject Re: Lack of use of indexes
Date
Msg-id Pine.LNX.4.33.0211220930520.25220-100000@css120.ihs.com
Whole thread Raw
In response to Re: Lack of use of indexes  (Don Isgitt <djisgitt@soundenergy.com>)
List pgsql-general
On Fri, 22 Nov 2002, Don Isgitt wrote:

> Thanks, Doug for your very prompt reply. This newsgroup is wonderful.
>
> It will take a while, but I will create the table with text fields to
> see if that helps. The query with ...section='14' did not use the index.

Note that you can also "cast" the field you're searching on...

select * from sometable where field='14'::char(5)




pgsql-general by date:

Previous
From: "Jan Weerts"
Date:
Subject: Re: help in starting up / shutting down postgres as another user
Next
From: Tom Lane
Date:
Subject: Re: improving a badly optimized query