Postgres Pro
Downloads
Home   >   mailing lists

Re: Deleting orphaned records (not exists is very slow) - Mailing list pgsql-general

From Tim Uckun
Subject Re: Deleting orphaned records (not exists is very slow)
Date
Msg-id AANLkTim3JnHiKBVvpjyD2H_RCWnUam2Ui6aRbko=iUwy@mail.gmail.com
Whole thread Raw
In response to Re: Deleting orphaned records (not exists is very slow)  (Michael Glaesemann <grzm@seespotcode.net>)
Responses Re: Deleting orphaned records (not exists is very slow)  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
List pgsql-general
Tree view 
> If the table is large, I sometimes use the following pattern:

The table is very large so I will use your advice thanks.

pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Deleting orphaned records (not exists is very slow)
Next
From: Tim Uckun
Date:
Subject: Killing "stuck" queries and preventing queries from getting "stuck"