| From: | Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> |
|---|---|
| To: | Corey Huinker <corey(dot)huinker(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Joel Jacobson <joel(at)trustly(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Idea on how to simplify comparing two sets |
| Date: | 2017-02-24 03:03:31 |
| Message-ID: | 79b72a5e-6b9d-d1f9-a202-6d0972ff995b@BlueTreble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Nasby | 2017-02-24 03:12:57 | Re: Automatic cleanup of oldest WAL segments with pg_receivexlog |
| Previous Message | Michael Paquier | 2017-02-24 03:01:12 | Re: Automatic cleanup of oldest WAL segments with pg_receivexlog |