Re: View with and without ::text casting performs differently.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: View with and without ::text casting performs differently.
Дата
Msg-id 2215.1378492532@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: View with and without ::text casting performs differently.  (Brian Fehrle <brianf@consistentstate.com>)
Ответы Re: View with and without ::text casting performs differently.  (Mark Mayo <djmornyc@gmail.com>)
Re: View with and without ::text casting performs differently.  (Brian Fehrle <brianf@consistentstate.com>)
Список pgsql-performance
Brian Fehrle <brianf@consistentstate.com> writes:
> On 09/05/2013 05:50 PM, Tom Lane wrote:
>> I rather doubt that the now-explicit-instead-of-implicit casts have much
>> to do with that.  It seems more likely that you forgot to re-ANALYZE in
>> the new database, or there are some different planner settings, or
>> something along that line.

> I have two versions of the view in place on the same server, one with
> the typecasting and one without, and this is where I see the differences
> (no ::text runs in 0.5ms and with ::text runs in 13 or so minutes with
> nested loop), so it's all running off the same statistics on the data.

Hm.  Can you provide a self-contained example?

            regards, tom lane


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

Предыдущее
От: Brian Fehrle
Дата:
Сообщение: Re: View with and without ::text casting performs differently.
Следующее
От: Mark Mayo
Дата:
Сообщение: Re: View with and without ::text casting performs differently.