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-QHFX3eWitZM6Cn6c0RMQKf6H0TZvTWp5SC0xd+7H3iNNDzQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Feature request (or at least discussion): enable autovaccum ontemp tables  (Christopher Browne <cbbrowne@gmail.com>)
Список pgsql-general
hi,

On Fri, 31 May 2019 at 17:54, Christopher Browne <cbbrowne@gmail.com> wrote:
 
2.  Temp tables are only associated (and visible) in the session in which you are doing the work.  autovacuum operates inside an ordinary session context, and in a separate connected session, so it can't see your temp tables; they are not handled in shared memory that crosses contexts to the one in which those temp tables exist.  Changing that would be way more difficult than meets the eye.

Hmm yeah, I forgot about that aspect - temp tables not going though shared buffers.

Thanks!

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

Предыдущее
От: Sathish Kumar
Дата:
Сообщение: Inherit Database - Table Permissions
Следующее
От: Ivan Voras
Дата:
Сообщение: Re: Feature request (or at least discussion): enable autovaccum ontemp tables