Re: [HACKERS] Idea on how to simplify comparing two sets

On 2/23/17 3:33 PM, Corey Huinker wrote:
> I've had to do it with temp tables any time the environment is different
> between control/experiment, which is the case when you're developing a
> drop-in replacement for an SRF or view or whatever.

FWIW I'd recommend temp views, to give the planner the most latitude. 
Less load from (presumably) pointless copying too.
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)