[postgis-users] Strange Performance issue
schabi at logix-tt.com
Fri Oct 14 07:19:14 PDT 2005
Markus Schaber wrote:
>> -> Index Scan using cntry_name_idx on country
>>(cost=0.00..805.94 rows=209 width=32) (actual time=0.043..0.288 rows=1
> ^^^ ^^^
> Hmm, that looks as it has a misestimation about the hits in the country
> table, and so chooses a suboptimal query plan, especially as you said
> that the country table had about 200 rows.
Another hint: You could try to create the cntry_name index as UNIQUE.
More information about the postgis-users