VACUUM FREEZE and replication lag

From: Martín Fernández <fmartin91(at)gmail(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: VACUUM FREEZE and replication lag
Date: 2019-03-05 01:53:54
Message-ID: 5c7dd55a59ae5a0000b663c7@polymail.io
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello everyone,

We have a very big table in our pg92 database that requires a manual vacuum freeze in order to keep sane number of transaction ids available. Yesterday we did a vacuum freeze on this table that took roughly 9 hours. After performing the operation we got back roughly 0.5 billion transaction ids. I was wondering how much this operation can affect replication lag? If vacuum freeze needs to mark a lot of tuples to the xfrozenid, will this mean that a lot of informaton is going to be stremead in the way files? Just trying understand the relation. As soon as we started the operation, our standbys that have the lower io got significantly impacted for several hours. 

Thanks!

Martín

Browse pgsql-general by date

  From Date Subject
Next Message Julie Nishimura 2019-03-05 03:11:23 Re: master-> 2 hot standbys
Previous Message Ben Chobot 2019-03-05 01:08:04 Re: master-> 2 hot standbys