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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Why performance improvement on converting subselect to a function ?
Дата
Msg-id 4578.1059514334@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Why performance improvement on converting subselect  (Rajesh Kumar Mallah <mallah@trade-india.com>)
Ответы Re: Why performance improvement on converting subselect to a function ?  (Rajesh Kumar Mallah <mallah@trade-india.com>)
Список pgsql-performance
Rajesh Kumar Mallah <mallah@trade-india.com> writes:
> Tom Lane wrote:
>> Odd.  Apparently the planner is picking a better plan in the function
>> context than in the subselect context --- which is strange since it
>> ought to have less information.

> [ verbose plan snipped ]

Well, that sure seems to be the same plan.  Curious that the runtime
wasn't about the same.  Perhaps the slow execution of the first query
was a caching effect?  If you alternate trying the query both ways,
does the speed difference persist?

            regards, tom lane

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

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