Re: Lack of use of indexes

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Don Isgitt <djisgitt(at)soundenergy(dot)com>
Cc: Doug McNaught <doug(at)mcnaught(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Lack of use of indexes
Date: 2002-11-22 16:31:33
Message-ID: Pine.LNX.4.33.0211220930520.25220-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-11-22 16:34:13 Re: improving a badly optimized query
Previous Message Jan Weerts 2002-11-22 16:25:35 Re: help in starting up / shutting down postgres as another user