Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 2EF884774C5
	for <pgsql-sql@postgresql.org>; Tue, 28 Jan 2003 22:41:53 -0500 (EST)
Received: from davinci.ethosmedia.com (unknown [209.10.40.251])
	by postgresql.org (Postfix) with ESMTP id D09B9477695
	for <pgsql-sql@postgresql.org>; Tue, 28 Jan 2003 21:45:47 -0500 (EST)
Received: from [216.135.165.74] (account <josh@agliodbs.com>)
	by davinci.ethosmedia.com (CommuniGate Pro WebUser 4.0.2)
	with HTTP id 2526086; Tue, 28 Jan 2003 18:45:17 -0800
From: "Josh Berkus" <josh@agliodbs.com>
Subject: Re: Problem with query
To: Ricardo Javier Aranibar =?ISO-8859-1?Q?Le=F3n?= =?ISO-8859-1?Q?_?=
	<ricardo_jal@hotmail.com>, pgsql-sql@postgresql.org
Cc: ricardo_jal@linuxmail.org
X-Mailer: CommuniGate Pro Web Mailer v.4.0.2
Date: Tue, 28 Jan 2003 18:45:17 -0800
Message-ID: <web-2526086@davinci.ethosmedia.com>
In-Reply-To: <F143kvAdxaQ6shalxyP00000884@hotmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200301/453
X-Sequence-Number: 11318

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