Re: [PERFORM] View with and without ::text casting performs differently.

2013-09-06 Thread Mark Mayo
Good Afternoon, I also came across this too. The issue goes away if you keep your join columns the same data type on both tables. The nested loop happens when the join columns are not the same data type. Hope this helps. Best -Mark On Fri, Sep 6, 2013 at 2:35 PM, Tom Lane wrote: > Brian Fehrl

Re: [PERFORM] View with and without ::text casting performs differently.

2013-09-06 Thread Mark Mayo
*Sorry correction. I meant the Materialize disappears when the join columns are the same data type. On Fri, Sep 6, 2013 at 3:46 PM, Mark Mayo wrote: > Good Afternoon, > > I also came across this too. > The issue goes away if you keep your join columns the same data type on > bot