Re: Partitioned TEMP tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ed Behn <ed(dot)behn(at)rockwellcollins(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Partitioned TEMP tables
Date: 2017-07-31 20:16:51
Message-ID: 16463.1501532211@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ed Behn <ed(dot)behn(at)rockwellcollins(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ed Behn 2017-07-31 20:19:14 Re: Partitioned TEMP tables
Previous Message Peter J. Holzer 2017-07-31 20:11:00 Re: Dealing with ordered hierarchies