Postgres Pro
Downloads
Home   >   mailing lists

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

From Michael Glaesemann
Subject Re: Deleting orphaned records (not exists is very slow)
Date
Msg-id B8A8CFF6-BEB5-444E-A2B1-18A8DDF0A325@seespotcode.net
Whole thread Raw
In response to Re: Deleting orphaned records (not exists is very slow)  (Tim Uckun <timuckun@gmail.com>)
Responses Re: Deleting orphaned records (not exists is very slow)  (Tim Uckun <timuckun@gmail.com>)
List pgsql-general
Tree view 
On Sep 27, 2010, at 22:08 , Tim Uckun wrote:

> update to_be_deleted set mark = true where ctid  = any (array( select
> ctid from to_be_deleted limit 10));

Why are you messing with ctid? Does the table have no key? If not, you should fix that first.

Michael Glaesemann
grzm seespotcode net

pgsql-general by date:

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