Re: [Proposal] Global temporary tables

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: [Proposal] Global temporary tables
Дата
Msg-id CAFj8pRBTPK5UzKt3uXo=Q2AmP9PuKvgwNUj=Aod7+iyr9iLccQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [Proposal] Global temporary tables  (Adam Brusselback <adambrusselback@gmail.com>)
Список pgsql-hackers
Дерево обсуждения


st 2. 3. 2022 v 19:02 odesílatel Adam Brusselback <adambrusselback@gmail.com> napsal:
>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.

This strongly depends on usage.  Very common patterns from MSSQL don't need statistics. But on second thought, sometimes, the query should be divided and temp tables are used for storing some middle results. In this case, you cannot exist without statistics. In the first case, the temp tables can be replaced by arrays. In the second case, the temp tables are not replaceable.

Regards

Pavel

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

Предыдущее
От: Joshua Brindle
Дата:
Сообщение: Re: [PoC/RFC] Multiple passwords, interval expirations
Следующее
От: Bharath Rupireddy
Дата:
Сообщение: Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs)