Problebs with index in 7.0
От | Peter Keller |
---|---|
Тема | Problebs with index in 7.0 |
Дата | |
Msg-id | 3934BA32.8D266ED4@bvv.bayern.de обсуждение исходный текст |
Список | 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.Keller@bvv.bayern.de 80538 Muenchen : web: http://www.bayern.de/vermessung
В списке pgsql-general по дате отправления: