Re: Using CTE vs temporary tables

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Using CTE vs temporary tables
Дата
Msg-id CAKFQuwaYortq=bLUdNCsCS9+f9Ub+E_a0TH9168XyPnWCKaLxw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Using CTE vs temporary tables  (Ravi Krishna <sravikrishna3@gmail.com>)
Ответы Re: Using CTE vs temporary tables  (Adam Brusselback <adambrusselback@gmail.com>)
Список pgsql-general
On Wed, Jul 11, 2018 at 9:35 AM, Ravi Krishna <sravikrishna3@gmail.com> wrote:
​Does temp tables also suffer from optimization fence we see in CTE.​

​I suppose it depends on how they end up being referenced in the query.  It is not possible for the auto-vacuum daemon to vacuum/analyze them so if you aren't doing that manually there will be a different kind of problem (bad stats) preventing the query from being executed efficiently.  But in terms of the "barrier", no, they are no different than any other table added to a query FROM list.

David J.

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

Предыдущее
От: Ravi Krishna
Дата:
Сообщение: Re: Using CTE vs temporary tables
Следующее
От: Adam Brusselback
Дата:
Сообщение: Re: Using CTE vs temporary tables