Re: View with and without ::text casting performs differently. - Mailing list pgsql-performance

From Tom Lane
Subject Re: View with and without ::text casting performs differently.
Date
Msg-id 2215.1378492532@sss.pgh.pa.us
Whole thread Raw
In response to Re: View with and without ::text casting performs differently.  (Brian Fehrle <brianf@consistentstate.com>)
Responses 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>)
List 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 by date:

Previous
From: Brian Fehrle
Date:
Subject: Re: View with and without ::text casting performs differently.
Next
From: Mark Mayo
Date:
Subject: Re: View with and without ::text casting performs differently.