| 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: | Whole Thread | Raw Message | 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 |