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 Alvaro Herrera <alvherre@commandprompt.com>
Re: autovacuum and temp tables support Robert Haas <robertmhaas@gmail.com>
Re: autovacuum and temp tables support "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: autovacuum and temp tables support Oleg Bartunov <oleg@sai.msu.su>
Re: autovacuum and temp tables support Robert Haas <robertmhaas@gmail.com>
Re: autovacuum and temp tables support Bruce Momjian <bruce@momjian.us>
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
Дата:
От: Kevin Grittner
Дата:
FAQ