Hi On Thu, Jul 18, 2024 at 10:26 AM Durgamahesh Manne < maheshpostgr...@gmail.com> wrote:
> Hi > > Do new inserts block while performing vacuum freeze operations ? > Generally, VACUUM FREEZE does not block inserts as PG uses Multi-Version Concurrency Control (MVCC) which allows multiple transactions to operate on the same table without interfering with each other. > > when autovacuum runs , it will freeze the transaction ID (TXID) of the > table it's working on. This means that any transactions that started before > autovacuum began will be allowed to complete.but new transactions will be > blocked until the autovacuum finishes. > > Could you please provide more clarity on this? Which lock triggers on the > tables are being used by freeze? > > Your response is highly appreciated > > Regards, > Durga Mahesh > > >
