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