From: Josh Berkus <josh@agliodbs.com>
To: Ricardo Javier Aranibar León <ricardo_jal@hotmail.com>
To: pgsql-sql@postgresql.org
Cc: ricardo_jal@linuxmail.org
Subject: Re: Problem with query
Date: Tue, 28 Jan 2003 18:45:17 -0800
Message-ID: <web-2526086@davinci.ethosmedia.com> (raw)
In-Reply-To: <F143kvAdxaQ6shalxyP00000884@hotmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: josh@agliodbs.com, ricardo_jal@hotmail.com, ricardo_jal@linuxmail.org
Subject: Re: Problem with query
In-Reply-To: <web-2526086@davinci.ethosmedia.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox