Re: High cost of ... where ... not in (select ...)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: High cost of ... where ... not in (select ...)
Дата
Msg-id 14283.1245211578@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: High cost of ... where ... not in (select ...)  (Aaron Turner <synfinatic@gmail.com>)
Список pgsql-performance
Aaron Turner <synfinatic@gmail.com> writes:
> I know the costs are just relative, but I assumed
> cost=19229.08..29478.99 isn't 5 minutes of effort even on crappy
> hardware.

Very likely the bulk of the time is spent in the DELETE work proper,
not in the query to find the rows to be deleted.  In particular I wonder
if you have an unindexed foreign key referencing this table ...

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Bryce Ewing
Дата:
Сообщение: Index Scan taking long time
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Yet another slow nested loop