Re: Deleting 173000 records takes forever, blocks async queries for unrelated records - Mailing list pgsql-general

>># delete from pref_users
>>where id not in (select distinct id from pref_money) limit 10;
>>ERROR:  syntax error at or near "limit"
>>LINE 2: ...ere id not in (select distinct id from pref_money) limit 10;

Or this?

DELETE FROM pref_users
WHERE id IN (
    SELECT id
    FROM pref_users
    WHERE id NOT IN (
        SELECT DISTINCT id
        FROM pref_money
    )
    LIMIT 10
);

Saw elsewhere another suggestion with EXCEPT, which is also sexy.