Re: DELETE SQL too slow.

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@ikono.com.br
Ikono Sistemas e Automação
http://www.ikono.com.br