| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Uros Gruber <uros(dot)gruber(at)sir-mag(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Help with performance |
| Date: | 2002-04-25 13:25:06 |
| Message-ID: | 20020425232506.C24529@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)svana(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2002-04-25 13:34:45 | Re: How to deal with crashes? |
| Previous Message | Tom Jenkins | 2002-04-25 13:17:29 | Re: Speeding query |