From: | Peter Keller <peter(dot)keller(at)bvv(dot)bayern(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Problebs with index in 7.0 |
Date: | 2000-05-31 07:07:30 |
Message-ID: | 3934BA32.8D266ED4@bvv.bayern.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all,
I made an update (pg_dump) from 6.5 to 7.0 (i686-pc-linux-gnu, compiled
by gcc egcs-2.91.66),
I created an index on column gmkg_tl by doing:
create index ix_flurst_gmkg_tl_ix on flurstueck using btree (gmkg_tl
bpchar_ops);
gmkg_tl is char(16).
When I do a
select * from flurstueck where gmkg_tl = 'kaBV00110x9W06Zq';
in version 6.5 the query plan is:
Aggregate (cost=124.82 rows=1217 width=12)
-> Index Scan using ix_flurst_gmkg_tl on flurstueck (cost=124.82
rows=1217 width=12)
this is ok but when I do the same thing in version 7.0 the query plan
is:
NOTICE: QUERY PLAN:
Seq Scan on flurstueck (cost=0.00..4784.31 rows=2445 width=16)
yes, I did a vacuum/vacuum analyze
Some ideas???
Thanks,
Peter
--
Bezirksfinanzdirektion Muenchen
Vermessungsabteilung
.........................................................
Peter Keller : Tel: (+49) 089-2190-2594
Vermessungsrat z.A.: Fax: (+49) 089-2190-2459
Alexandrastr. 3 : mailto:Peter(dot)Keller(at)bvv(dot)bayern(dot)de
80538 Muenchen : web: http://www.bayern.de/vermessung
From | Date | Subject | |
---|---|---|---|
Next Message | Radu Coroi | 2000-05-31 07:50:26 | |
Previous Message | Tom Lane | 2000-05-31 06:17:55 | Re: Perl interfaces? |