Re: [GENERAL] Partitioned TEMP tables

2017-08-01 Thread Ed Behn
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.b...@rockwellcollins.com www.rockwellcollins.com On Mon, Jul 31, 2017 at 4:16 PM,

Re: [GENERAL] Partitioned TEMP tables

2017-07-31 Thread Tom Lane
Ed Behn writes: > I tried that. I didn't seem to help. Well, it works in a simple test case for me. You'll need to post a self-contained example that's not working if you want much help ... regression=# create temp table pp(f1 int, f2 text); CREATE TABLE regression=# create temp table c1(check(

Re: [GENERAL] Partitioned TEMP tables

2017-07-31 Thread Tom Lane
Ed Behn 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