Re: Deleting orphaned records (not exists is very slow)

Поиск
Список
Период
Сортировка
От Michael Glaesemann
Тема Re: Deleting orphaned records (not exists is very slow)
Дата
Msg-id B8A8CFF6-BEB5-444E-A2B1-18A8DDF0A325@seespotcode.net
обсуждение исходный текст
Ответ на Re: Deleting orphaned records (not exists is very slow)  (Tim Uckun <timuckun@gmail.com>)
Ответы Re: Deleting orphaned records (not exists is very slow)  (Tim Uckun <timuckun@gmail.com>)
Список pgsql-general
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Killing "stuck" queries and preventing queries from getting "stuck"
Следующее
От: Tim Uckun
Дата:
Сообщение: Re: Deleting orphaned records (not exists is very slow)