Re: [HACKERS] Idea on how to simplify comparing two sets - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: [HACKERS] Idea on how to simplify comparing two sets
Date
Msg-id 79b72a5e-6b9d-d1f9-a202-6d0972ff995b@BlueTreble.com
Whole thread Raw
In response to Re: [HACKERS] Idea on how to simplify comparing two sets  (Corey Huinker <corey.huinker@gmail.com>)
List pgsql-hackers
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)



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [HACKERS] Automatic cleanup of oldest WAL segments with pg_receivexlog
Next
From: Jim Nasby
Date:
Subject: Re: [HACKERS] Automatic cleanup of oldest WAL segments withpg_receivexlog