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 1sTAe6-00Dfoj-F0 for pgsql-hackers@arkaria.postgresql.org; Mon, 15 Jul 2024 01:36:54 +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 1sTAe4-007X9I-BK for pgsql-hackers@arkaria.postgresql.org; Mon, 15 Jul 2024 01:36:52 +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 1sTAe4-007X9A-1H for pgsql-hackers@lists.postgresql.org; Mon, 15 Jul 2024 01:36:52 +0000 Received: from mail-yw1-x1136.google.com ([2607:f8b0:4864:20::1136]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sTAe1-0025dD-Jg for pgsql-hackers@postgresql.org; Mon, 15 Jul 2024 01:36:50 +0000 Received: by mail-yw1-x1136.google.com with SMTP id 00721157ae682-654cf0a069eso31854377b3.1 for ; Sun, 14 Jul 2024 18:36:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1721007409; x=1721612209; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=pUjVkTBsUIvCySLjmoVnCXLVeGQuJr6nhkrZXbCuOb4=; b=GeC+csO2rQ96jA5E3NRGc18dTaqR/qVMcZjjJRH2nXzNK3sJdnKO6nxdhzWp01STNl 4ksEEMXVHWUQ4p5AIRnq0AsGDc+L5MULQ0Cj5hvXiRZaVelA+HFRZSXQSU2AEEAwZ+Oe 7TpH9ZqfR677KmhyJM6Ic6/nWjWTQ/T+RJYuGcaj0CEBDz/cegFDTe74dm8E4K4YBL2k sI1cgwR+xrIWAmWURP/d+rgxWC4MUZjxnoifPT+lqt5W2tFc7Y2L6df0iMhMy0Ms1wFQ jvAZ1IrAFb0eq2ewko62DO4YALsVkVR5hHJztIYe91QWi5hrzZ5XRMJayxU4aDdkdKqF IW8A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1721007409; x=1721612209; h=content-transfer-encoding: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=pUjVkTBsUIvCySLjmoVnCXLVeGQuJr6nhkrZXbCuOb4=; b=R6MoCTjoOHCImfqwmlQbBcE1C2i7ToGvqjln8ddm5MdaGlXaJT0i4hl4BEpcRbyWb+ WxIKn0q9MndemYUS8iS6bHmHAXujpdnYPDo3W1PJvNMwXgDrn6brfWjZc7YQxZ6Ss7cb vyeTgLcTm+uQyzzcXSNXEF1T6HWOIr09vr1ahAW8EJhJCk8WlCLcQvXZaTMa0Cb6Gqz0 mrsrQwt72aLwnB6aHCsxuVHsKCh4Tei5Y5qUPRQsXGRLS1hQxxjhE2oG8ULs4osKFIeP PfQIgOEFj0gJzY70qpHKcV+uyV2FFcOCzKauGbJ0Ln6xSiJTW5UlXTCTByGOnFem3xBR zsJg== X-Gm-Message-State: AOJu0YxirdMVnzws6LW9xlyuw2g0y57jyiyLMxbrnk9MaiPBPt0qo5b3 zLI1q4LxRrSOp2HqgacZr7HVQ/Xed3+Rx6egjm4P6x2gIEtH3KTALQ2n/XpAZXx7LFhBvv5vQhT Blsrbvugcwl3d1MLu2W5UAOxPAdU= X-Google-Smtp-Source: AGHT+IEpfHy98K/hSHbYGzGgIXxZV6wJDgskCeYbYSpRbFOAW/OnR23lC3LijxWBdDlxeic5nIlGkj2YepTJcMvl6ug= X-Received: by 2002:a81:5b42:0:b0:65f:e307:d41 with SMTP id 00721157ae682-65fe3070dc7mr51622877b3.16.1721007408836; Sun, 14 Jul 2024 18:36:48 -0700 (PDT) MIME-Version: 1.0 References: <1724688.1688837323@sss.pgh.pa.us> In-Reply-To: From: Richard Guo Date: Mon, 15 Jul 2024 09:36:37 +0800 Message-ID: Subject: Re: Check lateral references within PHVs for memoize cache keys To: Andrei Lepikhov Cc: PostgreSQL-development , David Rowley , Tom Lane Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Jul 11, 2024 at 5:18=E2=80=AFPM Richard Guo wrote: > Attached is an updated version of this patch. I've pushed this patch. Thanks for all the reviews. Thanks Richard