Search Postgresql Archives

If crashes during VACUUM, will it recover from a checkpoint that is before the forzen transaction ID of VACUUM?

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

 



Hello All,

When VACUUM starts, it will calculate a frozen transaction ID and freeze all tuples older than it. Will this frozen TXID younger than the latest checkpoint? 

If this is the case, then when the system crashes after VACUUM has deleted some dead tuples and the system recovers from this checkpoint, these tuples will be available to some transactions again during the replaying of WAL.  

I am new to Postgres, hope my understanding is not too wrong.

Thanks,
Reatank

[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