Re: "not in" clause too slow?
От
Rodrigo De León
Тема
Re: "not in" clause too slow?
Дата
Msg-id
a55915760709210719k1202df02u29542bd05b8f9652@mail.gmail.com
Ответ на
"not in" clause too slow? (Ottavio Campana)
Список
Дерево обсуждения
"not in" clause too slow? Ottavio Campana <ottavio@campana.vi.it>
Re: "not in" clause too slow? Martijn van Oosterhout <kleptog@svana.org>
Re: "not in" clause too slow? Alban Hertroys <a.hertroys@magproductions.nl>
Re: "not in" clause too slow? Ottavio Campana <ottavio@campana.vi.it>
Re: "not in" clause too slow? panther-d@freemail.hu
Re: "not in" clause too slow? Ottavio Campana <ottavio@campana.vi.it>
Re: "not in" clause too slow? "Rodrigo De León" <rdeleonp@gmail.com>
On 9/21/07, Ottavio Campana wrote: > My problem is that if I run the same command on another > table with 378415 rows, it is terribly slow. How much is "terribly slow"? Did you VACUUM ANALYZE? Anyways, try this: SELECT * FROM MYTABLE T1 LEFT JOIN COPY_MYTABLE T2 ON T1.ID = T2.ID WHERE T2.ID IS NULL
В списке pgsql-general по дате отправления
