Re: [GENERAL] Accelerating subqueries

[Ed Loehr]

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