Re: Performance of NOT IN and <> with PG 9.0.4

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Performance of NOT IN and <> with PG 9.0.4
Дата
Msg-id 4884.1306332801@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Performance of NOT IN and <> with PG 9.0.4  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Performance of NOT IN and <> with PG 9.0.4  (Jasmin Dizdarevic <jasmin.dizdarevic@gmail.com>)
Список pgsql-sql
Robert Haas <robertmhaas@gmail.com> writes:
> On Tue, May 24, 2011 at 3:32 PM, Jasmin Dizdarevic
> <jasmin.dizdarevic@gmail.com> wrote:
>> enable_material = off

> Is there any chance you can reproduce this with a simpler test case
> that doesn't involve quite so many joins?

I didn't stop to count, but are there enough that join_collapse_limit
or from_collapse_limit could be in play?
        regards, tom lane


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Performance of NOT IN and <> with PG 9.0.4
Следующее
От: Rob Sargent
Дата:
Сообщение: Re: extracting location info from string