X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 95144D1B472
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 26 Apr 2004 15:58:03 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 97239-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 26 Apr 2004 15:58:01 -0300 (ADT)
Received: from tht.net (vista.tht.net [216.126.88.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 96C08D1B436
	for <pgsql-sql@postgresql.org>; Mon, 26 Apr 2004 15:57:59 -0300 (ADT)
Received: from [134.22.68.249] (dyn-68-249.tor.dsl.tht.net [134.22.68.249])
	by tht.net (Postfix) with ESMTP
	id 4C9CD76A78; Mon, 26 Apr 2004 14:58:03 -0400 (EDT)
Subject: Re: problem with slow select
From: Rod Taylor <pg@rbt.ca>
To: francescosaf <francescosaf.152kao@mail.webservertalk.com>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <francescosaf.152kao@mail.webservertalk.com>
References: <francescosaf.152kao@mail.webservertalk.com>
Content-Type: text/plain
Message-Id: <1083005880.30065.6.camel@jester>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.5 
Date: Mon, 26 Apr 2004 14:58:00 -0400
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200404/290
X-Sequence-Number: 17665

On Wed, 2004-04-21 at 11:00, francescosaf wrote:
> hi 
> 
> I have two tables:

Please send results of EXPLAIN ANALYZE for the query in question.

Thanks