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

От: Alvaro Herrera
Тема: Re: High cost of ... where ... not in (select ...)
Дата: ,
Msg-id: 20090616213750.GN7519@alvh.no-ip.org
(см: обсуждение, исходный текст)
Ответ на: High cost of ... where ... not in (select ...)  (Aaron Turner)
Ответы: Re: High cost of ... where ... not in (select ...)  (Aaron Turner)
Список: pgsql-performance

Скрыть дерево обсуждения

High cost of ... where ... not in (select ...)  (Aaron Turner, )
 Re: High cost of ... where ... not in (select ...)  (Alvaro Herrera, )
  Re: High cost of ... where ... not in (select ...)  (Aaron Turner, )
   Re: High cost of ... where ... not in (select ...)  (Robert Haas, )
    Re: High cost of ... where ... not in (select ...)  (Aaron Turner, )
     Re: High cost of ... where ... not in (select ...)  (Robert Haas, )
      Re: High cost of ... where ... not in (select ...)  (Aaron Turner, )
      Re: High cost of ... where ... not in (select ...)  (Aaron Turner, )
       Re: High cost of ... where ... not in (select ...)  (Tom Lane, )

Aaron Turner escribió:
> I'm trying to figure out how to optimize this query (yes, I ran vacuum/analyze):
>
> musecurity=# explain DELETE FROM muapp.pcap_store WHERE pcap_storeid
> NOT IN (SELECT pcap_storeid FROM muapp.pcap_store_log);

What PG version is this?


--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


В списке pgsql-performance по дате сообщения:

От: Aaron Turner
Дата:
Сообщение: Re: High cost of ... where ... not in (select ...)
От: Bryce Ewing
Дата:
Сообщение: Index Scan taking long time