Re: Feature request (or at least discussion): enable autovaccum ontemp tables

Поиск
Список
Период
Сортировка
От Ivan Voras
Тема Re: Feature request (or at least discussion): enable autovaccum ontemp tables
Дата
Msg-id CAF-QHFXWKe5iA+bLVM6wo8jP__R6HmoXCLVHcucwhkUwkJ7_BQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Feature request (or at least discussion): enable autovaccum ontemp tables  (Adam Brusselback <adambrusselback@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Fri, 31 May 2019 at 17:38, Adam Brusselback <adambrusselback@gmail.com> wrote:
Temp tables are not visibile outside of a single connection, so the autovacuum worker connection isn't able to see it.

I can connect as a superuser via psql while temp tables are being used and I can examine tables in the pg_temp_* schemas, so that particular separation isn't really a strong one. If there's a reason why autovacuum isn't doable on temp tables, it's not that one. (maybe autovacuum would work on the tables while the session disconnects, preventing the temp tables from being dropped?)

 

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

Предыдущее
От: Adam Brusselback
Дата:
Сообщение: Re: Feature request (or at least discussion): enable autovaccum ontemp tables
Следующее
От: Andrew Gierth
Дата:
Сообщение: Re: Feature request (or at least discussion): enable autovaccum on temp tables