Re: Accelerating subqueries

Fabrice Scemama wrote:
>
> DELETE FROM Annonces WHERE Id_Ag IN
> (
>     SELECT Id FROM Installs
>     WHERE Si_Compte_Actif = 'f'
> );
>
> This query will take more than one hour of CPU time

> Any ideas about a way to write a single query that fast ?

http://www.postgresql.org/docs/faq-english.html#4.23