Re: First steps with 8.3 and autovacuum launcher

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: First steps with 8.3 and autovacuum launcher
Дата
Msg-id 874ph6zzop.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Re: First steps with 8.3 and autovacuum launcher  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: First steps with 8.3 and autovacuum launcher  (Simon Riggs <simon@2ndquadrant.com>)
Re: First steps with 8.3 and autovacuum launcher  (Heikki Linnakangas <heikki@enterprisedb.com>)
Re: First steps with 8.3 and autovacuum launcher  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: First steps with 8.3 and autovacuum launcher  (Gregory Stark <stark@enterprisedb.com>)
Список pgsql-hackers
"Alvaro Herrera" <alvherre@commandprompt.com> writes:

> Hmm, it looks like the race condition Heikki mentioned is the culprit.
> We need a way to stop future analyzes from starting.  Back to the
> drawing board ...

A crazy idea I just had -- what if you roll this into the deadlock check? So
after waiting on the lock for 1s it wakes up, finds that the holder it's
waiting on is an autovacuum process and cancels it instead of finding no
deadlock.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com


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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: First steps with 8.3 and autovacuum launcher
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: First steps with 8.3 and autovacuum launcher