Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id D5564476048
	for <pgsql-sql@postgresql.org>; Tue,  2 Jul 2002 12:30:04 -0400 (EDT)
Mailbox-Line: From lego@127.0.0.1  Tue Jul  2 12:30:04 2002
Received: from news.hub.org (news.hub.org [64.49.215.80])
	by postgresql.org (Postfix) with ESMTP id 204854762AC
	for <pgsql-sql@postgresql.org>; Tue,  2 Jul 2002 11:44:32 -0400 (EDT)
Received: by news.hub.org (Postfix, from userid 8)
	id B3C383818E3; Tue,  2 Jul 2002 11:44:01 -0400 (EDT)
From: Ahti Legonkov <lego@127.0.0.1>
X-Newsgroups: comp.databases.postgresql.sql
Subject: Why doesn't it use indexes?
Date: Tue, 02 Jul 2002 18:46:59 +0300
Lines: 22
Message-ID: <3D21CAF3.8090508@127.0.0.1>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@kadri.ut.ee
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.0rc3) Gecko/20020523
X-Accept-Language: en-us, en
To: pgsql-sql@postgresql.org
X-Spam-Status: No, hits=2.8 required=5.0
	tests=SUBJ_ENDS_IN_Q_MARK,DOUBLE_CAPSWORD,NO_MX_FOR_FROM
	version=2.30
X-Spam-Level: **
X-Archive-Number: 200207/21
X-Sequence-Number: 8400

Hi,

I have this query:
select * from reo inner join usr on reo.owner_id=usr.user_id

I also have created these indexes:
CREATE INDEX "owner_id_reo_key" ON reo (owner_id);
CREATE INDEX "user_id_user_key" ON usr (user_id);

Explain tells me this:
Merge Join  (cost=1341.74..1481.12 rows=299697 width=461)
   ->  Sort  (cost=775.05..775.05 rows=6629 width=328)
         ->  Seq Scan on apartment_reo reo  (cost=0.00..354.29 rows=6629 
width=328)
   ->  Sort  (cost=566.69..566.69 rows=4521 width=133)
         ->  Seq Scan on USER usr  (cost=0.00..292.21 rows=4521 width=133)

Why it does not use indexes I have created?

-- 
Ahti Legonkov