| From: | Ed Behn <ed(dot)behn(at)rockwellcollins(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Partitioned TEMP tables |
| Date: | 2017-07-31 20:19:14 |
| Message-ID: | CAE1kc7XSraiymnvM3=C-2Dxq0R11kO2THYu8NPnt8pR_Q2gCDQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)behn(at)rockwellcollins(dot)com
On Mon, Jul 31, 2017 at 4:16 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2017-07-31 20:59:50 | Re: Question about loading up a table |
| Previous Message | Tom Lane | 2017-07-31 20:16:51 | Re: Partitioned TEMP tables |