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?
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 |