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 1u3L3U-00EGpk-0w for pgsql-hackers@arkaria.postgresql.org; Fri, 11 Apr 2025 20:32:52 +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 1u3L3R-00E5Mk-J5 for pgsql-hackers@arkaria.postgresql.org; Fri, 11 Apr 2025 20:32:49 +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 1u3L3R-00E5Mb-1s for pgsql-hackers@lists.postgresql.org; Fri, 11 Apr 2025 20:32:49 +0000 Received: from mail-pj1-x1029.google.com ([2607:f8b0:4864:20::1029]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u3L3O-004nXq-21 for pgsql-hackers@postgresql.org; Fri, 11 Apr 2025 20:32:48 +0000 Received: by mail-pj1-x1029.google.com with SMTP id 98e67ed59e1d1-306b78ae2d1so2339384a91.3 for ; Fri, 11 Apr 2025 13:32:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=leadboat.com; s=google; t=1744403564; x=1745008364; darn=postgresql.org; h=user-agent: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=AfVQP2ofVJ2pImxM4SvfpZbovmoZt0/m6pHfoKKhhdI=; b=YZewfKWxMfNDvmxAytt5XPPV7MrHRXm3TSBY7IqeqPLXOH4NDtzEWKxCKH/S5Ro8l4 7+d5UIpeJs53eW572NSni5zEJPN4gpN1FF191CO3GHAmq9Fpj1ZL/fAF6M6eR3rg3b3M 8BUSBZNHMtPcNYh32NLZTSdx++T1deEFB8lNI= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744403564; x=1745008364; h=user-agent: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=AfVQP2ofVJ2pImxM4SvfpZbovmoZt0/m6pHfoKKhhdI=; b=AnOu7cFJe4De+eXeGr83UFCpSJPIx6h3+12WszFo1hA3wenoZTvalyyb1uLCS/Whcz hlu/OiQVZ5dBQDV8QiBmvCBnDAM6Wk3e2DbBwUeL84aMuKvCz5O0H3e90ZyWHpWepDXc 9Hq5/mEZ1X7kOlYW12Nl/bI6SMgzxR+JoAWO03GrTbbRcAQBzJ1AeNS9ieu07rUv/74d YsDxneltHqSVKbWmlyGRl6WEc1XSVbSmf+AUY0e3zpUZVGK9MJ4p2pkDLAJh91MtvH2j L0NxSc0n/kAXgKfNsi7Cefj0E061HM47tkEWBBsBg6z3q7oSocb0KTWci865G0H8qcwz 4Kgw== X-Forwarded-Encrypted: i=1; AJvYcCX1QI+w4H8J6P0w3RKlwAsA+A1C8Xn1vgr436WdHoIHBFSMIWzyCkzAeQyfk0pH9ym6Arj0zVV0c8Sw7uFg@postgresql.org X-Gm-Message-State: AOJu0YwGO5d5xTb9FUDv5T0q8YRddyWTx1tlRCI/Lf9fKWMFu6ircBiW j3mNDLGGjif2WXRjrVohNnm3Cm7tVsYMAAJorbrEeBS4jDFJSWNcKtIrpYUMWg== X-Gm-Gg: ASbGnctjOO8IolyeXAO1Ahj25A3/brdEjsRUY3u7k+1nMiUfqm9voLSyYeRXSIKpWjz BaroxZ2ap/ld4TIz3WIYUvoM0vqZsX7Msu/ZSl3BDo1V1Zl0hzw5PBVW4628lYpcMb2R7Xd986n cMAblcjyoGafvOBLQ1t9CGQ7DabNLWttaMMclwtx4Z8IgFBTDrbwDGu8rqhnc/TBla2RudwkQdb EnVNoWlMjlJfAlOqwGp8o3D0bLjWfrpdq9UOauxRYqBkwSmVME3YvxkqR5j+Tz0BDfzTwtm+ML5 9yfD6m1KhaN01ofC1iGHbvoSOqu8YyhBRJIK7Q== X-Google-Smtp-Source: AGHT+IGCoccYZ1eZ/ImAiG+XMwMEyHgr71VAVz7PGP7elsvULWJswXYZKgtKzCPM/ZW/b2Mcoaqx1Q== X-Received: by 2002:a17:90b:3806:b0:2ee:e113:815d with SMTP id 98e67ed59e1d1-30823662bf6mr6596269a91.8.1744403564482; Fri, 11 Apr 2025 13:32:44 -0700 (PDT) Received: from google.com ([2601:647:5600:80d0::31cd]) by smtp.gmail.com with ESMTPSA id 98e67ed59e1d1-306df06a767sm6818628a91.6.2025.04.11.13.32.43 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Fri, 11 Apr 2025 13:32:44 -0700 (PDT) Date: Fri, 11 Apr 2025 13:32:41 -0700 From: Noah Misch To: Alexander Korotkov Cc: Pavel Borisov , Dagfinn Ilmari =?iso-8859-1?Q?Manns=E5ker?= , Andrei Lepikhov , jian he , Artur Zakirov , Alexander Lakhin , Teodor Sigaev , Pgsql Hackers , Aleksander Alekseev , Tom Lane , Michael Paquier Subject: Re: type cache cleanup improvements Message-ID: <20250411203241.e9.nmisch@google.com> References: <87y12i8i6f.fsf@wibble.ilmari.org> <87v7xl92x2.fsf@wibble.ilmari.org> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/2.2.12 (2023-09-09) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Oct 22, 2024 at 08:33:24PM +0300, Alexander Korotkov wrote: > On Tue, Oct 22, 2024 at 6:10 PM Pavel Borisov wrote: > > On Tue, 22 Oct 2024 at 11:34, Alexander Korotkov wrote: > >> I'm going to push this if no objections. (This became commit b85a9d0.) > + /* Call delete_rel_type_cache() if we actually cleared something */ > + if (hadTupDescOrOpclass) > + delete_rel_type_cache_if_needed(typentry); I think the intent was to maintain the invariant that a RelIdToTypeIdCacheHash entry exists if and only if certain kinds of data appear in the TypeCacheHash entry. However, TypeCacheOpcCallback() clears TCFLAGS_OPERATOR_FLAGS without maintaining RelIdToTypeIdCacheHash. Is it right to do that?