Re: auto-vacuum conflicting with long running analyze

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: auto-vacuum conflicting with long running analyze
Дата
Msg-id 2395.1207429651@sss.pgh.pa.us
обсуждение исходный текст
Ответ на auto-vacuum conflicting with long running analyze  (Shane Ambler <pgsql@Sheeky.Biz>)
Список pgsql-hackers
Shane Ambler <pgsql@Sheeky.Biz> writes:
> Would this be the issue fixed in 8.1.1? -
> Prevent autovacuum from crashing during ANALYZE of expression index

More likely this one:

2007-06-14 09:53  alvherre
* src/backend/commands/: vacuum.c (REL8_1_STABLE), vacuum.c(REL8_2_STABLE), vacuum.c: Avoid having autovacuum run
multipleANALYZEcommands in a single transaction, to prevent possibledeadlock problems.  Per request from Tom Lane.
 
        regards, tom lane


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

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: auto-vacuum conflicting with long running analyze
Следующее
От: Tom Lane
Дата:
Сообщение: machine-dependent hash_any vs the regression tests