Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: [GENERAL] Partitioned TEMP tables
Date
Msg-id 16463.1501532211@sss.pgh.pa.us
Whole thread Raw
In response to [GENERAL] Partitioned TEMP tables  (Ed Behn <ed.behn@rockwellcollins.com>)
Responses Re: [GENERAL] Partitioned TEMP tables  (Ed Behn <ed.behn@rockwellcollins.com>)
List pgsql-general
Tree view 
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: "Peter J. Holzer"
Date:
Subject: Re: [GENERAL] Dealing with ordered hierarchies
Next
From: Ed Behn
Date:
Subject: Re: [GENERAL] Partitioned TEMP tables