Postgres Pro
Downloads
Home   >   mailing lists

Re Deleting 173000 records takes forever - Mailing list pgsql-general

From hamann.w@t-online.de
Subject Re Deleting 173000 records takes forever
Date
Msg-id 510B9748.mail8UI198K27@amadeus3.local
Whole thread Raw
Responses Postgres version number support  (Martin Gainty <mgainty@hotmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Neil Worden
Date:
Subject: Re: naming of wal-archives
Next
From: Albe Laurenz
Date:
Subject: Re: Deleting 173000 records takes forever, blocks async queries for unrelated records