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

On Tue, Jun 16, 2009 at 2:37 PM, Alvaro
Herrera<alvherre@commandprompt.com> wrote:
> 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?

Doh, just realized I didn't reply back to list.   It's version 8.3.3.

Also, pcap_storeid is unique in pcap_store_log


--
Aaron Turner
http://synfin.net/
http://tcpreplay.synfin.net/ - Pcap editing and replay tools for Unix & Windows
Those who would give up essential Liberty, to purchase a little temporary
Safety, deserve neither Liberty nor Safety.
    -- Benjamin Franklin