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