Search Postgresql Archives

VACUUM FREEZE and replication lag

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux