Re: again on index usage (7.1.3)

>>>Stephan Szabo said:
>
> Let's start with the standard set of things. Have you vacuum analyzed,
> what does explain show for the query, is there one value that is more
> common than all others?
>

My most recent 'standard' answer these days is "it worked well before VACUUM
ANALYZE" :-)

RADIUS=# explain
select * from attrib where user_name = 'Paacons'RADIUS-# ;
NOTICE: QUERY PLAN:

Seq Scan on attrib (cost=0.00..16978.46 rows=17922 width=48)

EXPLAIN

is what explain says by default.

RADIUS=# set enable_seqscan='off';
SET VARIABLE

RADIUS=# explain
select * from attrib where user_name = 'Paacons';
NOTICE: QUERY PLAN:

Index Scan using uattr on attrib (cost=0.00..32861.00 rows=17922 width=48)

EXPLAIN

Daniel