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)
Ответы: Re: Why performance improvement on converting subselect  (Rajesh Kumar Mallah)
Список: pgsql-performance


Rajesh Kumar Mallah <> 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
От: "scott.marlowe"
Дата:
Сообщение: Re: postgresql.conf