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)
Список
Дерево обсуждения
Deleting orphaned records (not exists is very slow) Tim Uckun <timuckun@gmail.com>
Re: Deleting orphaned records (not exists is very slow) Grzegorz Jaśkiewicz <gryzman@gmail.com>
Re: Deleting orphaned records (not exists is very slow) Michael Glaesemann <grzm@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) Grzegorz Jaśkiewicz <gryzman@gmail.com>
Re: Deleting orphaned records (not exists is very slow) Tim Uckun <timuckun@gmail.com>
Re: Deleting orphaned records (not exists is very slow) Michael Glaesemann <grzm@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) Michael Glaesemann <grzm@seespotcode.net> 

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
Дата:
Следующее
От: Tim Uckun
Дата:
FAQ