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

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

Are you sure that it's actually an issue with accumulating dead tuples, and not an issue with bad statistics?

In my processes which are heavy on temp tables, I have to manually run analyze after populating any temp tables.

Just a thought.
-Adam

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

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