Re Deleting 173000 records takes forever

From: hamann(dot)w(at)t-online(dot)de
To: pgsql-general(at)postgresql(dot)org
Subject: Re Deleting 173000 records takes forever
Date: 2013-02-01 10:22:00
Message-ID: 510B9748.mail8UI198K27@amadeus3.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Alexander Farber wrote:
delete from pref_users
where id not in (select distinct id from pref_money);

Hi,

try instead
delete from pref_users
where id in (select id from pref_users except select id from pref_money);

Regards
Wolfgang Hamann

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2013-02-01 10:38:35 Re: Deleting 173000 records takes forever, blocks async queries for unrelated records
Previous Message Neil Worden 2013-02-01 10:15:01 Re: naming of wal-archives