>> 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.
