MIME-Version: 1.0
From: Durgamahesh Manne <maheshpostgres9@gmail.com>
Date: Thu, 18 Jul 2024 10:57:10 +0530
Message-ID: <CAJCZko+DMHw2Cuqu09EKCW_1256GE4qfnhN-BV1X0Uoj0G2JFg@mail.gmail.com>
Subject: Regarding vacuum freeze locking mechanism
To: pgsql-general@lists.postgresql.org
Cc: andrian.klaver@aklaver.com
Content-Type: multipart/alternative; boundary="0000000000008fb97b061d7ed062"
Archived-At: <https://www.postgresql.org/message-id/CAJCZko%2BDMHw2Cuqu09EKCW_1256GE4qfnhN-BV1X0Uoj0G2JFg%40mail.gmail.com>
Precedence: bulk

--0000000000008fb97b061d7ed062
Content-Type: text/plain; charset="UTF-8"

Hi

Do new inserts block while performing vacuum freeze operations ?

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

--0000000000008fb97b061d7ed062
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi<div><br></div><div>Do new inserts block while performin=
g vacuum freeze operations ?</div><div><br></div><div>when autovacuum runs =
, it will freeze the transaction=C2=A0ID (TXID) of the table it&#39;s worki=
ng on. This means that any transactions that started before autovacuum bega=
n will be allowed to complete.but new transactions will be blocked until th=
e autovacuum finishes.</div><div><br></div><div>Could you please provide mo=
re clarity=C2=A0on this? Which lock triggers on the tables are being=C2=A0u=
sed by freeze?</div><div><br></div><div>Your response is highly appreciated=
</div><div><br></div><div>Regards,</div><div>Durga Mahesh=C2=A0</div><div><=
br></div><div><br></div></div>

--0000000000008fb97b061d7ed062--