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 1srcse-003Lrz-PM for pgsql-general@arkaria.postgresql.org; Fri, 20 Sep 2024 12:37:01 +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 1srcsc-005Pxm-R3 for pgsql-general@arkaria.postgresql.org; Fri, 20 Sep 2024 12:37:00 +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 ) id 1srcpU-005Jsd-Bn for pgsql-general@lists.postgresql.org; Fri, 20 Sep 2024 12:33:45 +0000 Received: from mail-ej1-x630.google.com ([2a00:1450:4864:20::630]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1srcpS-000BZo-0P for pgsql-general@lists.postgresql.org; Fri, 20 Sep 2024 12:33:45 +0000 Received: by mail-ej1-x630.google.com with SMTP id a640c23a62f3a-a8d0d0aea3cso247994666b.3 for ; Fri, 20 Sep 2024 05:33:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1726835622; x=1727440422; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=rMHfZlxI2hPQf9p1RuOZYcOFQopt40+VsGf+U6pjyrQ=; b=WO9ST6xw0hIuA9YMa1lYAJTKEDE0294z0LJf/JgrD9zEHx2PXowJFYjphCpvQ1KmFb AuCdFdwMvt0n8yJvRSntdMdSiXw0mf5hule/PJjbepShgfRHtxkHVzKRADtADkrth/0g 2rROZ0RALOJ0ww94IZxB0TTYv3VFsUAcT4OonacrNzdvFm/ly9Rmsm0TP0KqJzsLUQqE 7yk4M9IgdXpAy7eyVM6BhnggqmxCkEJrm5LqJBu9KrfqWE1Kw8IecMjaXn+Cx9+vdasy 4vvKKLTXgWzsDULY+8l39FY3+vfDfZKz0SakECQtPQHiqJyOYN3/tsM/vY0CreGDwChC jSzw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726835622; x=1727440422; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=rMHfZlxI2hPQf9p1RuOZYcOFQopt40+VsGf+U6pjyrQ=; b=VzdDVxa9BAEZhkfsKhYbUgv01I3eAzNFSMCPBrAXvPHAddNgu8CCOOyLv+MftVr5yX 9cpSMz+QMWczXcVyXweEeRmUZTx+PUgE6A9CaM3HCnobU38flnDGfkXEii4seo1UNprQ 6hRwVfeCevvIWVLN4LfgUtN7IusSdTsml+GjJPZvitaK0wz60F71BHTs1ar1e11PIBQ6 qx1hjKiaRDxr/zhYWuUlQIDHVoSqM47KqQ/IeYTEMPn61RgZuUl6QCES2mkQ8TEMADJk diygulytZpG9GxlW8xNBskYvDb+GgYLAHymuuzHc+jjJ/U2q/JIFJs6IetBMjRDmsNZi jJag== X-Forwarded-Encrypted: i=1; AJvYcCUr/Ch4d3Ix1JkYG6shJTLYtsUIPp9LycXeA5u/q+QEyuRY2ami9IRXQgSDrPQJ4EvPHuL/+249T7FzdzWX@lists.postgresql.org X-Gm-Message-State: AOJu0YytOWI567gG2Ov38UnamniIomPCPR8yBOgj2uUH1zQ4BqNu68uN URv7Zx+oL8hn8GwWfJpF7zIs38uBpG2mIM/hhpChudwUQwdfx0ShB2kc0I5s0wU= X-Google-Smtp-Source: AGHT+IF2sW+BxsR6rF79IaEXZLqb8eiazrjOCHYs9B8rfbAw65+TuN4GpHCzuzBaQCB/Ff3uGUA6Jw== X-Received: by 2002:a17:907:f74e:b0:a86:9c41:cfc1 with SMTP id a640c23a62f3a-a90d4fe01e1mr229737266b.8.1726835622221; Fri, 20 Sep 2024 05:33:42 -0700 (PDT) Received: from dynamic-pd01.res.v6.highway.a1.net ([2001:871:5e:9d01:b2d:4032:5ab9:9a8d]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-a906133195csm836876466b.220.2024.09.20.05.33.41 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 20 Sep 2024 05:33:42 -0700 (PDT) Message-ID: <6a024c2fe9da23f4bc33ce92a4ef5645698c4e20.camel@cybertec.at> Subject: Re: pg_locks in production From: Laurenz Albe To: Wizard Brony , pgsql-general@lists.postgresql.org Date: Fri, 20 Sep 2024 14:33:41 +0200 In-Reply-To: <230A1A3E-E09D-4A39-991A-DF739F4D12F8@gmail.com> References: <230A1A3E-E09D-4A39-991A-DF739F4D12F8@gmail.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.52.4 (3.52.4-1.fc40) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2024-09-19 at 15:08 -0400, Wizard Brony wrote: > If performance is not an issue, is it valid to use the pg_locks > system view in production code? Or are there other concerns > besides performance that would make its use inappropriate for production? There are no concerns if you use pg_locks on a production system. Yours, Laurenz Albe