Search Postgresql Archives

Re: Regarding vacuum freeze locking mechanism

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

 



On Wednesday, July 17, 2024, Durgamahesh Manne <maheshpostgres9@xxxxxxxxx> wrote:
when autovacuum runs , it will freeze the transaction ID (TXID) of the table it's working on.

This statement is incorrect.  A table as a whole does not have a txid.  Freezing makes it so individual tuples get assigned an always-in-the-past txid.  Then, the table can recompute how far away its furthest back txid is from being considered in-the-future.  That gap should increase since the furthest away txids were the ones being frozen.

Inserts might get delayed a brief moment if it just happens the page they want to insert onto is presently being worked on.  But the odds there seem low.

David J.


[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 Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux