Re: 8.4/9.0 simple query performance regression

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 8.4/9.0 simple query performance regression
Дата
Msg-id 14955.1307401343@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 8.4/9.0 simple query performance regression  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
Дерево обсуждения 
Josh Berkus <josh@agliodbs.com> writes:
> Just got this simple case off IRC today:
> [ hashed versus non-hashed subplan ]
> I'm at a bit of a loss as to what's happening here.

Possibly work_mem is smaller in the second installation?

(If I'm counting on my fingers right, you'd need a setting of at least a
couple MB to let it choose a hashed subplan for this case.)

            regards, tom lane

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

Предыдущее
От: Mike Broers
Дата:
Сообщение: Re: poor performance when recreating constraints on large tables
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: not exits slow compared to not in. (nested loops killing me)