Re: Why performance improvement on converting subselect to a function ?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Why performance improvement on converting subselect to a function ?
Дата
Msg-id 9198.1059573083@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Why performance improvement on converting subselect to a function ?  (Rajesh Kumar Mallah <mallah@trade-india.com>)
Ответы Re: Why performance improvement on converting subselect  (Rajesh Kumar Mallah <mallah@trade-india.com>)
Список pgsql-performance
Дерево обсуждения 
Rajesh Kumar Mallah <mallah@trade-india.com> writes:
> What lead to degradation was the bumping off of
> effective_cache_size parameter from 1000 to 64K

Check the plan then; AFAIR the only possible effect of changing
effective_cache_size is to influence which plan the planner picks.

            regards, tom lane

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

Предыдущее
От: Rajesh Kumar Mallah
Дата:
Сообщение: Re: Why performance improvement on converting subselect to a function ?
Следующее
От: "Shridhar Daithankar"
Дата:
Сообщение: Re: Why performance improvement on converting subselect to a function ?