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

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема Re: Feature request (or at least discussion): enable autovaccum on temp tables
Дата
Msg-id 87r28eaaxm.fsf@news-spur.riddles.org.uk
обсуждение исходный текст
Ответ на 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
>>>>> "Ivan" == Ivan Voras <ivoras@gmail.com> writes:

 Ivan> Since AFAIK temp tables are very close to unlogged ordinary
 Ivan> tables, what would stop this feature from being implemented?

The key difference between temp tables and other tables is that temp
table data does not use the shared_buffers but is buffered only in
backend-local memory.

This means that other processes (like, say, an autovacuum process) can
not access the content of temp tables. So what you want is not possible.

-- 
Andrew (irc:RhodiumToad)



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

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