Re: [GENERAL] Partitioned TEMP tables

Поиск
Список
Период
Сортировка
От Ed Behn
Тема Re: [GENERAL] Partitioned TEMP tables
Дата
Msg-id CAE1kc7XSraiymnvM3=C-2Dxq0R11kO2THYu8NPnt8pR_Q2gCDQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Partitioned TEMP tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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.behn@rockwellcollins.com

www.rockwellcollins.com


On Mon, Jul 31, 2017 at 4:16 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] Partitioned TEMP tables
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: [GENERAL] Question about loading up a table