Re: [GENERAL] Partitioned TEMP tables - Mailing list pgsql-general

From Ed Behn
Subject Re: [GENERAL] Partitioned TEMP tables
Date
Msg-id CAE1kc7XSraiymnvM3=C-2Dxq0R11kO2THYu8NPnt8pR_Q2gCDQ@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Partitioned TEMP tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I tried that. I didn't seem to help. 


Ed Behn / Staff Engineer / Airline and Network Services
Information Management Services
2551 Riva Road, Annapolis, MD 21401 USA
Phone: (410)266-4426 / Cell: (240)696-7443
ed.behn@rockwellcollins.com

www.rockwellcollins.com


On Mon, Jul 31, 2017 at 4:16 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Ed Behn <ed.behn@rockwellcollins.com> writes:
> Does partitioning of TEMP tables not work like non-TEMP tables?

Should be the same ... but you don't get any auto-analyze support on
a temp table.  I wonder if you're remembering to ANALYZE the temp
tables after you've populated them.

                        regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Partitioned TEMP tables
Next
From: Scott Marlowe
Date:
Subject: Re: [GENERAL] Question about loading up a table