Re: Problem with query

Ricardo,

For future notice, there is another mailing list, PGSQL-PERFORMANCE,
devoted to questions like yours.

> select * from llamada where fecha='20030127' and tipo=1 and tiempo>0
> and gwdes like '64.7.127.14%' order by hora desc;
>
> It's very slow, it takes approximately 6 minutes to show me the
> results. I saw that it's happend when I execute this types of queries
> "Select...gwdes like '64.7.127.14%'.." or with field gworg.
> But when i use others fields the time that it take is faster.
> I used PostgreSQL 7.0.3 and I have only problem with this type query.

Are you using 7.0.3 now, or something more current? I can't really
help you much with 7.0.3.

-Josh