Hash Join not using hashed index?

From: Ang Chin Han <angch(at)pintoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Hash Join not using hashed index?
Date: 2000-06-28 05:24:11
Message-ID: 20000628132411.B29825@pollcities.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I'm using Postgresql 7.02.

======================================================================
# explain select city.name, country.name from country, city
where city.country_id = country.country_id;
NOTICE: QUERY PLAN:

Hash Join (cost=8.85..16.76 rows=75 width=18)
-> Seq Scan on city (cost=0.00..1.75 rows=75 width=16)
-> Hash (cost=5.53..5.53 rows=253 width=2)
-> Seq Scan on country (cost=0.00..5.53 rows=253 width=2)

EXPLAIN
# create index country_id_idx on country using hash (country_id);
CREATE
# vacuum analyze;
VACUUM
# explain select city.name, country.name from country, city
where city.country_id = country.country_id;
NOTICE: QUERY PLAN:

Hash Join (cost=8.85..16.76 rows=75 width=18)
-> Seq Scan on city (cost=0.00..1.75 rows=75 width=16)
-> Hash (cost=5.53..5.53 rows=253 width=2)
-> Seq Scan on country (cost=0.00..5.53 rows=253 width=2)

EXPLAIN
======================================================================

Why doesn't PostgreSQL use country_id_idx, but rather rehashing
country_id?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-06-28 06:15:40 Re: Problem with pg_dumpall
Previous Message Ryan Bradetich 2000-06-27 23:14:35 Re: Problem with pg_dumpall