Re: [GENERAL] Partitioned TEMP tables

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

Re: [GENERAL] Partitioned TEMP tables

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

Re: [GENERAL] Partitioned TEMP tables

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.

[GENERAL] Partitioned TEMP tables

I have an issue regarding partitioned TEMP tables. I have a database with a number of families of tables partitioned by day as described in section 5.10 of the User's Manual. I have an empty parent tables each with a number of child tables containing data partitioned by date. Each child has a