Search Postgresql Archives

Re: Partitioned TEMP tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.behn@xxxxxxxxxxxxxxxxxxx

www.rockwellcollins.com


On Mon, Jul 31, 2017 at 4:16 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Ed Behn <ed.behn@xxxxxxxxxxxxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux