Re: Autovacuum Improvements

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Autovacuum Improvements
Дата
Msg-id 20070116142525.GW24671@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Autovacuum Improvements  ("Simon Riggs" <simon@2ndquadrant.com>)
Список pgsql-general
Simon Riggs wrote:

> Perhaps we should focus on the issues that might result, so that we
> address those before we spend time on the details of the user interface.
> Can we deadlock or hang from running multiple autovacuums?

If you were to run multiple autovacuum processes the way they are today,
maybe.  But that's not my intention -- the launcher would be the only
one to read the catalogs; the workers would be started only to do a
single VACUUM job.  This reduces the risk of this kind of problems.

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

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

Предыдущее
От: "Jasbinder Singh Bali"
Дата:
Сообщение: Re: Dynamic loading of Perl Code in Postgres functions
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: [HACKERS] Autovacuum Improvements