Re: autovacuum and temp tables support

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: autovacuum and temp tables support
Дата
Msg-id 20100408185351.GH4126@alvh.no-ip.org
обсуждение исходный текст
Ответ на autovacuum and temp tables support  (Oleg Bartunov <oleg@sai.msu.su>)
Ответы Re: autovacuum and temp tables support
Список pgsql-hackers
Oleg Bartunov wrote:

> our client complained about slow query, which involves temporary tables.
> Analyzing them manually solved the problem. I don't remember
> arguments against temporary tables support by autovacuum. I'd
> appreciate any
> pointers.

Autovacuum can't process temp tables; they could reside in a backend's
private temp buffers (local memory, not shared).

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: A maze of twisty mailing lists all the same
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: A maze of twisty mailing lists all the same