Re: Help with performance - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Help with performance
Date
Msg-id 20020425232506.C24529@svana.org
Whole thread Raw
In response to Help with performance  (Uros Gruber <uros.gruber@sir-mag.com>)
List pgsql-general
On Wed, Apr 24, 2002 at 10:49:12PM +0200, Uros Gruber wrote:

First you have:
>  id_entry       | integer

Then you have:
>  id_entry    | character varying(64)

> Not i have  query like this
>
> select d.title from table1 d, table2 c where c.id_category='09' and d.id_entry=c.id_entry;

With those types so different, it makes it difficult to use indexes in
certain ways. Perhaps an explicit cast?

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Canada, Mexico, and Australia form the Axis of Nations That
> Are Actually Quite Nice But Secretly Have Nasty Thoughts About America

pgsql-general by date:

Previous
From: Tom Jenkins
Date:
Subject: Re: Speeding query
Next
From: Martijn van Oosterhout
Date:
Subject: Re: How to deal with crashes?