I think the "VACUUM ANALYZE" solution should be given great prominence in
the FAQ.
Possibly add to:
4.9) My queries are slow or don't make use of the indexes. Why?
http://www.postgresql.org/docs/faq-english.html#4.9
New first lines:
Make sure relevant indexes exist (see 4.8) then try VACUUM ANALYZE from psql.
If that doesn't work, read the rest. And if THAT doesn't clear things up,
then it's something which the mailing lists and developers probably want to
know.
Cheerio,
Link.
At 06:40 PM 18-05-2000 -0300, Diego Schvartzman wrote:
>Hi !
>I destroyed my db and created again, 'vacuum' it and seems to be everything
>ok.
>Now I'm getting this (wich is much better than before). Thanks all !
>
>explain select * from d_cue where clave = '9400001';
>NOTICE: QUERY PLAN:
>
>Index Scan using d_cue_clave on d_cue (cost=0.00..1.69 rows=1 width=544)
>
>
>
>