From: Tom Lane <tgl@sss.pgh.pa.us>
To: Brian Fehrle <brianf@consistentstate.com>
cc: pgsql-performance@postgresql.org
Subject: Re: View with and without ::text casting performs differently.
In-reply-to: <522A05E1.1070103@consistentstate.com>
References: <5229097C.4070401@consistentstate.com>
 <1960.1378425018@sss.pgh.pa.us> <522A05E1.1070103@consistentstate.com>
Comments: In-reply-to Brian Fehrle <brianf@consistentstate.com>
 message dated "Fri, 06 Sep 2013 10:42:09 -0600"
Date: Fri, 06 Sep 2013 14:35:32 -0400
Message-ID: <2215.1378492532@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

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


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance