I already have ran VACUUM ANALYSE
And I used the REINDEX too.
Here is the explain:
NOTICE: QUERY PLAN:
Index Scan using palavrasbusca_codbusca_ix on palavrasbusca
(cost=0.00..333.43 rows=443 width=6)
My SQL is still running, it been more than one hour.
The table has a reference to one other table and it has an index.
>First try to VACUM ANALYZE.
>if this dont help, try to drop the index and recrate it ?
>
>also do you have enugh ram ?
>
--
Diogo de Oliveira Biazus
diogo(at)ikono(dot)com(dot)br
Ikono Sistemas e Automação
http://www.ikono.com.br