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