Re: [HACKERS] Transaction held open by autoanalyze can be abottleneck - Mailing list pgsql-hackers

From Andres Freund
Subject Re: [HACKERS] Transaction held open by autoanalyze can be abottleneck
Date
Msg-id 20170510202602.iq6bt2sk4njm22ic@alap3.anarazel.de
Whole thread Raw
In response to [HACKERS] Transaction held open by autoanalyze can be a bottleneck  (Jeff Janes <jeff.janes@gmail.com>)
List 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 by date:

Previous
From: "Sven R. Kunze"
Date:
Subject: Re: [HACKERS] Adding support for Default partition in partitioning
Next
From: Robert Haas
Date:
Subject: Re: [HACKERS] Bug in pg_dump --table and --exclude-table fordeclarative partition table handling.