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 ) id 1sUKAA-002Awz-F4 for pgsql-general@arkaria.postgresql.org; Thu, 18 Jul 2024 05:58:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sUKA8-00Agdw-Ja for pgsql-general@arkaria.postgresql.org; Thu, 18 Jul 2024 05:58:45 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sUKA8-00Agdo-6j for pgsql-general@lists.postgresql.org; Thu, 18 Jul 2024 05:58:44 +0000 Received: from mail-oi1-x231.google.com ([2607:f8b0:4864:20::231]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sUKA5-0008m3-C7 for pgsql-general@lists.postgresql.org; Thu, 18 Jul 2024 05:58:43 +0000 Received: by mail-oi1-x231.google.com with SMTP id 5614622812f47-3d92df7e83cso459926b6e.0 for ; Wed, 17 Jul 2024 22:58:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1721282321; x=1721887121; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=Ca/3tI/oP8rAtEQNvgPQ3lpa+zKU81Cdg3Ipo3Xpdbk=; b=kbCLX5Jup/e+bTuiznEp8WnnhHHOZsmFzAD228N72FFPXudupG+w3FLdW/PvQeBp80 mvZc3x4bGyKUYtIC6I9+4bs2jtXkNe3haDgL2L0Q97O1luNLlrndlkGNZ1IaANOvaZQh HiRfnLpN9VngN0P9hOZR1h+pBfh8tQ36ysVY5vYc+f+1XDcjiEqv7+ZSydiKEcM1Rds6 +i/ODWQ9TA5NKF4gc8pd4r8Qf3E96tA0ZVGfPYyoHcQiXjJAmkcBRfLE1DI0+9ZiQaOa 0iBr2klFeNsv0OuuyIMXapEOTD4aNQ9BxZOboZpgEDS6J219bpDPJyPnjoTgrktR1Afu Z4sg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1721282321; x=1721887121; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=Ca/3tI/oP8rAtEQNvgPQ3lpa+zKU81Cdg3Ipo3Xpdbk=; b=Vmv0VWzPrwi3ESoYX7LBsWgxDeNADBXkWeH9STJN6tAPswGuM8Wsop8zd+EGBg1UJx ya8TJo0nxh7tKeopOcZRIMTEMkxCAlw16JseAlHIliI/N4nybb2fsT8fS7DCeUoxMmPA GpbnCRtT3/2iL8bHru598qK5HCe3zvXNHGpNwoFO/lHlfGA7dOuEmoUQsctUb2lwiSeh w7N9i8SjIjabIuf3E+Alx0JqiyAd21W8oRNkc1IQSWZ2mRULJu33XVPgkPUffrg5XpfS JN/tVQAToBds/ZGc+m+TcqnR6zYGIB/jaZC+YrZu1dh5nkyr1meG0+XpzciN2WLYl52x 1CcA== X-Gm-Message-State: AOJu0YxK8u+KNXFt8GchFazEFaCfNFKLKiTmkz2qLsN1Nx/KjIwUWRcI M1iP+8PG8pAV3lJLe0asQuuiYQ5P2Z974dBQfO0ZfgSpfyfes8c3PODLJt3emoJzG3NGf/xYmbG XCz4nkHRGSnHFEpCKQCM+62B8kRA= X-Google-Smtp-Source: AGHT+IEK7wX4xloKQq/lKa5rT6SoIpTR3zmL64XvE3m+XHBrU2cUzTwFpKMUswDwj14bFcvxERdkxRM6tFOa5En7aFI= X-Received: by 2002:a05:6808:13c3:b0:3d9:3f3f:a65c with SMTP id 5614622812f47-3dad73c8bc7mr1005973b6e.8.1721282320755; Wed, 17 Jul 2024 22:58:40 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a05:6802:29a5:b0:539:aa10:6c7 with HTTP; Wed, 17 Jul 2024 22:58:40 -0700 (PDT) In-Reply-To: References: From: "David G. Johnston" Date: Wed, 17 Jul 2024 22:58:40 -0700 Message-ID: Subject: Re: Regarding vacuum freeze locking mechanism To: Durgamahesh Manne Cc: "pgsql-general@lists.postgresql.org" Content-Type: multipart/alternative; boundary="00000000000049757e061d7f4583" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000049757e061d7f4583 Content-Type: text/plain; charset="UTF-8" On Wednesday, July 17, 2024, Durgamahesh Manne wrote: > > Could you please provide more clarity on this? Which lock triggers on the > tables are being used by freeze? > https://www.postgresql.org/docs/current/explicit-locking.html Share update exclusive David J. --00000000000049757e061d7f4583 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wednesday, July 17, 2024, Durgamahesh Manne <maheshpostgres9@gmail.com> wrote:

Could you please = provide more clarity=C2=A0on this? Which lock triggers on the tables are be= ing=C2=A0used by freeze?

=
Share update exclusive=C2=A0

David = J.

--00000000000049757e061d7f4583--