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 1qOlSz-008rlh-Sa for pgsql-hackers@arkaria.postgresql.org; Wed, 26 Jul 2023 20:50:41 +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 1qOlSx-006Cpf-IU for pgsql-hackers@arkaria.postgresql.org; Wed, 26 Jul 2023 20:50:39 +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 1qOlSx-006CpW-93 for pgsql-hackers@lists.postgresql.org; Wed, 26 Jul 2023 20:50:39 +0000 Received: from mail-pl1-x62d.google.com ([2607:f8b0:4864:20::62d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qOlSu-000XvU-FI for pgsql-hackers@postgresql.org; Wed, 26 Jul 2023 20:50:38 +0000 Received: by mail-pl1-x62d.google.com with SMTP id d9443c01a7336-1bb7b8390e8so1496395ad.2 for ; Wed, 26 Jul 2023 13:50:35 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1690404634; x=1691009434; h=in-reply-to:content-transfer-encoding:content-disposition :mime-version:references:message-id:subject:cc:to:from:date:from:to :cc:subject:date:message-id:reply-to; bh=kIsVbwCFtpATDsLPszj8qJR1D4wCNQaRrPypcrwlldE=; b=T9qhxNi1KZI9KMFZT6ZIUnlb0a7obvAs9wJhFKMfO9TkrzcnI6iHA4i9qTcfH8c7wX 4MmFg8gZXnqIBnAYYL4HXood1S1J6bD/UgaVI3P6OkLxispDvdvITsdbLeFudT9gYvLE CiI/NKthu1j2pMHIeeoThv+uvJCCRnZ6nqy4cc47CvUJF80HuUUNS7vJEGU8Y5+YN9rn 2q86l2WyH7FIi+OiJJWrDfMF1TnPk3sA6rmDIoIUBi5NVGLKcCfJYHGVvrkoJiD/KZJ4 DoGveQDDgV40UsLRY9ENI+RuCt3+MrfOrvjO2aXzywGKcCwMpFgDhuaXQAuB3R8cT2b5 G4bw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1690404634; x=1691009434; h=in-reply-to:content-transfer-encoding:content-disposition :mime-version:references:message-id:subject:cc:to:from:date :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=kIsVbwCFtpATDsLPszj8qJR1D4wCNQaRrPypcrwlldE=; b=jRWvya1q+AVZ1eVfnkPidUwHL6W0cTHs0rCjRqlIn2BjRuBdQRKypDQ3svi8pdqaWq 8e2SI1hWMgyjhzqs7SriQAF6AFGuPgAIkvDkWxqccmD2GNBhvDLl4Kc3nPFTjwd0iQ1g RBqrrqjWfFwxLXA/7o87Tb76iYz0oWYNQPJN+aojFe0Lf+E8ujL3gOK6Dpel1mwV0MrU ldx5+SLpXJKuTX3a4HxEuROBK8dhPlkOEsg3XEVHzDlxr5SdlVr54S8e4T70zEvf6O/8 9cEDJN41yZoxFS7imWjPRcPkrAF7PHAxipI+xvzfsUGV833AY6X3WgyG1hICv+ByodqB YLFw== X-Gm-Message-State: ABy/qLaQFMwpbfYmO71y/113uGHXkGzhQG+cIPJSff/jt4OoDj/lkqhq Zd8PjYUL7gtW2iG7k/mJp0g= X-Google-Smtp-Source: APBJJlEg/ubBz2FfAN1IqwwUkArzvGxv0Qx7GRZyhUeY/4uIyozFhXO8dOuffFcy6xdM4b2PzKv8dA== X-Received: by 2002:a17:903:2450:b0:1bb:a55d:c6d7 with SMTP id l16-20020a170903245000b001bba55dc6d7mr2948151pls.66.1690404633843; Wed, 26 Jul 2023 13:50:33 -0700 (PDT) Received: from nathanxps13 ([50.47.162.83]) by smtp.gmail.com with ESMTPSA id w2-20020a170902e88200b001a24cded097sm13605259plg.236.2023.07.26.13.50.32 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 26 Jul 2023 13:50:33 -0700 (PDT) Date: Wed, 26 Jul 2023 13:50:31 -0700 From: Nathan Bossart To: Dagfinn Ilmari =?iso-8859-1?Q?Manns=E5ker?= Cc: pgsql-hackers@postgresql.org Subject: Re: Obsolete reference to pg_relation in comment Message-ID: <20230726205031.GD3310393@nathanxps13> References: <87sf9apnr0.fsf@wibble.ilmari.org> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <87sf9apnr0.fsf@wibble.ilmari.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Okay, now looking at the patch... On Wed, Jul 26, 2023 at 06:48:51PM +0100, Dagfinn Ilmari Mannsåker wrote: > * All accesses to pg_largeobject and its index make use of a single Relation > - * reference, so that we only need to open pg_relation once per transaction. > + * reference, so that we only need to open pg_class once per transaction. > * To avoid problems when the first such reference occurs inside a > * subtransaction, we execute a slightly klugy maneuver to assign ownership of > * the Relation reference to TopTransactionResourceOwner. Hm. Are you sure this is actually referring to pg_class? It seems unlikely given pg_relation was renamed 14 years before this comment was added, and the code appears to be ensuring that pg_largeobject and its index are opened at most once per transaction. I couldn't find the original thread for this comment, unfortunately, but ISTM we might want to replace "pg_relation" with "them" instead. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com