>>>Stephan Szabo said:> > Let's start with the standard set of things. Have you vacuum analyzed,> what does explain
showfor 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