Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sUO4b-002gIj-KP
	for pgsql-general@arkaria.postgresql.org; Thu, 18 Jul 2024 10:09:17 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sUO4Z-00DkaN-6J
	for pgsql-general@arkaria.postgresql.org; Thu, 18 Jul 2024 10:09:15 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <maheshpostgres9@gmail.com>)
	id 1sUO4Y-00DkaF-Rb
	for pgsql-general@lists.postgresql.org; Thu, 18 Jul 2024 10:09:15 +0000
Received: from mail-ej1-x636.google.com ([2a00:1450:4864:20::636])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <maheshpostgres9@gmail.com>)
	id 1sUO4T-000BHS-Uh
	for pgsql-general@lists.postgresql.org; Thu, 18 Jul 2024 10:09:14 +0000
Received: by mail-ej1-x636.google.com with SMTP id a640c23a62f3a-a77c349bb81so58010866b.3
        for <pgsql-general@lists.postgresql.org>; Thu, 18 Jul 2024 03:09:09 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1721297349; x=1721902149; darn=lists.postgresql.org;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:from:to:cc:subject:date:message-id:reply-to;
        bh=nOda28S01GnGa/g9ZfwG0Ukg9o9l/Up8UW8o9jdj6/M=;
        b=biWINICGNVovcDDUi1CJJb/Ha/WsgBVQCnQ7rm44hN0J+Zhm4edcEG/zZ9zx6weuYW
         bHFrJkjLjury/JeqX2NpiK9DYhor7Mj9uemwyoEB0FmZDVv9OKRVuQLGw4fkIO0F1VIO
         w73JVLX1kKCOh3B7cLiSxI1t2ojM+FzyFKVMQaDIVSv1nvh2fdJc5ETidXCoVa2Mvtta
         k2fhnXk9HGEeWF/RUDnC0AUrekneLahkAGdsac7+DJeeq0x5RAwTUyDx6C4Twi/OtD0h
         9wp8d1gglzSIAamVPHB+5t1aVhkefMYT3B0uKhBc2GBGFFIxvNk4pcw0174ALaL73YhK
         PsrQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1721297349; x=1721902149;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id
         :reply-to;
        bh=nOda28S01GnGa/g9ZfwG0Ukg9o9l/Up8UW8o9jdj6/M=;
        b=U4LFrCqnIP/mEg5WQPEY/WS37snE1u3VhPn0sRnZtjoAAMPSsSzivUOw3ZpclXbbg9
         csspapiZ8xa03Y2Y/rEuToEMMBf79KC6WD/vv4YxrU8Up1RTQeW0rK//HNJrI336Po67
         o3ogiNivd0jasLzr5HzqgEzBc0KuNEhKM28I+kScJyRk0mPUwvvhJqthpxXRT6nJbwsK
         tqiubizmwFS9cf4ETqJ232nHTfjZUfX6d/nE1mR6wtrpKgrqUls38UsPqqxGklebzy4z
         /5GGn0UsEldpEES3Lsn9IzjldRGa5LM30NdWzpAxsr2PpsZLoSM6EIeYUwVqnZhlw8uh
         BVzQ==
X-Gm-Message-State: AOJu0YwxNVQld2Zt4AMApAEGnpeBU0dcKUTFJh+Btx3o61b0nWCMdSIZ
	mVx9GdXpAY7yYAFikyP5T0jogFRWCQ9a859PJc2l2VZdvm7jX8WQKiu3xeF2j2YZ8XhPBNfqSb0
	0mHuItSn1IWSiRrU0o/h8tkzdCSs=
X-Google-Smtp-Source: AGHT+IGBVAcgDKsHuKIK6Tnrwqu6Obsccs9Xn7RWEay9c6gdPcKICuZgwycmuhNKwyveMSuQeZS0DXuRO6Wool/5o/8=
X-Received: by 2002:a17:906:80d4:b0:a72:b287:1e04 with SMTP id
 a640c23a62f3a-a7a011ad86dmr285932466b.34.1721297348291; Thu, 18 Jul 2024
 03:09:08 -0700 (PDT)
MIME-Version: 1.0
References: <CAJCZko+DMHw2Cuqu09EKCW_1256GE4qfnhN-BV1X0Uoj0G2JFg@mail.gmail.com>
 <CAKFQuwbN6exXRdqrwfjg5qmhG-eFMUW_Urs4Q7mZpf327akg_Q@mail.gmail.com>
In-Reply-To: <CAKFQuwbN6exXRdqrwfjg5qmhG-eFMUW_Urs4Q7mZpf327akg_Q@mail.gmail.com>
From: Durgamahesh Manne <maheshpostgres9@gmail.com>
Date: Thu, 18 Jul 2024 15:40:16 +0530
Message-ID: <CAJCZkoL7GRw9ixXP_9-+6A-h-joGR2yAUXOxxb=MF8rMrbuXNQ@mail.gmail.com>
Subject: Re: Regarding vacuum freeze locking mechanism
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000ff742b061d82c43d"
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/CAJCZkoL7GRw9ixXP_9-%2B6A-h-joGR2yAUXOxxb%3DMF8rMrbuXNQ%40mail.gmail.com>
Precedence: bulk

--000000000000ff742b061d82c43d
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi David.

Excellent response from you .Great

Regards,
Durga Mahesh

On Thu, Jul 18, 2024 at 11:28=E2=80=AFAM David G. Johnston <
david.g.johnston@gmail.com> wrote:

> On Wednesday, July 17, 2024, Durgamahesh Manne <maheshpostgres9@gmail.com=
>
> wrote:
>
>>
>> Could you please provide more clarity on this? Which lock triggers on th=
e
>> tables are being used by freeze?
>>
>
>  https://www.postgresql.org/docs/current/explicit-locking.html
>
> Share update exclusive
>
> David J.
>
>

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

<div dir=3D"ltr">Hi=C2=A0David.<div><br></div><div>Excellent response from=
=C2=A0you .Great=C2=A0</div><div><br></div><div>Regards,</div><div>Durga Ma=
hesh</div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gm=
ail_attr">On Thu, Jul 18, 2024 at 11:28=E2=80=AFAM David G. Johnston &lt;<a=
 href=3D"mailto:david.g.johnston@gmail.com">david.g.johnston@gmail.com</a>&=
gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0=
px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On We=
dnesday, July 17, 2024, Durgamahesh Manne &lt;<a href=3D"mailto:maheshpostg=
res9@gmail.com" target=3D"_blank">maheshpostgres9@gmail.com</a>&gt; wrote:<=
br><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bord=
er-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div>=
<br></div><div>Could you please provide more clarity=C2=A0on this? Which lo=
ck triggers on the tables are being=C2=A0used by freeze?</div></div></block=
quote><div><br></div><div>=C2=A0<a href=3D"https://www.postgresql.org/docs/=
current/explicit-locking.html" target=3D"_blank">https://www.postgresql.org=
/docs/current/explicit-locking.html</a></div><div><br></div><div>Share upda=
te exclusive=C2=A0</div><div><br></div><div>David J.</div><div><br></div>
</blockquote></div>

--000000000000ff742b061d82c43d--