Re: [HACKERS] Transaction held open by autoanalyze can be abottleneck

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: [HACKERS] Transaction held open by autoanalyze can be abottleneck
Дата
Msg-id 20170510202602.iq6bt2sk4njm22ic@alap3.anarazel.de
обсуждение исходный текст
Ответ на [HACKERS] Transaction held open by autoanalyze can be a bottleneck  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
Hi,

On 2017-05-10 13:09:38 -0700, Jeff Janes wrote:
> Autovacuum's analyze starts a transaction when it starts on a table, and
> holds it for the duration. This holds back the xmin horizon.

Yea, I also complained about this:
http://archives.postgresql.org/message-id/20151031145303.GC6064%40alap3.anarazel.de


> Does analyze need all of its work done under the same transaction?

It's imo, as pointed out in the above email, not trivial to change it,
but it's imo doable.

Greetings,

Andres Freund

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

Предыдущее
От: "Sven R. Kunze"
Дата:
Сообщение: Re: [HACKERS] Adding support for Default partition in partitioning
Следующее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] Bug in pg_dump --table and --exclude-table fordeclarative partition table handling.