Re: [Proposal] Global temporary tables

Поиск
Список
Период
Сортировка
От Adam Brusselback
Тема Re: [Proposal] Global temporary tables
Дата
Msg-id CAMjNa7eVkffUz7OWgC_i9y0o18xSER750Y8oFqR=mdOYWV9ZUQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [Proposal] Global temporary tables  (Wenjing Zeng <wjzeng2012@gmail.com>)
Ответы Re: [Proposal] Global temporary tables
Список pgsql-hackers
>In my observation, very few users require an accurate query plan for temporary tables to
perform manual analyze.

Absolutely not true in my observations or personal experience. It's one of the main reasons I have needed to use (local) temporary tables rather than just materializing a CTE when decomposing queries that are too complex for Postgres to handle.

I wish I could use GTT to avoid the catalog bloat in those instances, but that will only be possible if the query plans are accurate.

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Chapman Flack
Дата:
Сообщение: Re: Add id's to various elements in protocol.sgml
Следующее
От: Joshua Brindle
Дата:
Сообщение: Re: [PoC/RFC] Multiple passwords, interval expirations