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.96) (envelope-from ) id 1w245Z-000qdX-2e for pgsql-hackers@arkaria.postgresql.org; Mon, 16 Mar 2026 09:18:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w244Z-008klE-2S for pgsql-hackers@arkaria.postgresql.org; Mon, 16 Mar 2026 09:17:16 +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.96) (envelope-from ) id 1w244Z-008kl6-1U for pgsql-hackers@lists.postgresql.org; Mon, 16 Mar 2026 09:17:16 +0000 Received: from mail-wr1-x42b.google.com ([2a00:1450:4864:20::42b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w244Y-00000000NGp-0jwZ for pgsql-hackers@lists.postgresql.org; Mon, 16 Mar 2026 09:17:15 +0000 Received: by mail-wr1-x42b.google.com with SMTP id ffacd0b85a97d-439bcec8613so3214375f8f.3 for ; Mon, 16 Mar 2026 02:17:14 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1773652633; cv=none; d=google.com; s=arc-20240605; b=hmlfFz+g0S9+dQJZcmXpHpqDH8Di4V3Q2BhknvPtSPUI8/bQVyldcVfPYdWxTlub8U YA7nfgMRvIW6iIO6bBeGSXxwK4ZXItUC+CN/bTNZXFnA/+jcC0HqVAjoGu6ZqnwcEq7a xL3hSzQWLKBogJB+MvBrMfmhn8syDYWySEhqdS3i6Cu9RokYHcVP6oZ7tMaWfLWTGbQR BxROy0IU4CiW0yw93MMR1ViZDTycW97PyWJqn4OhjvtZ2CLUNufUWY4U7yjaaEJ0CUeG 3Q+ny1q8qu1Eh0OTVDuf4nOKWRSRCUObsii95f4LpFdSBkRKDHiu+cSBP5VSzCAcyKHm QSCA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=hkdTbs5/4oZ1Uw5RYryF5V00ahOj9fKTIU58XFu/vcY=; fh=NA/hulOZHNMsXST3CWTNUOOPfGbacSAopiH1JV1/b3c=; b=jNuwpe9y590+WuKNtl4OFTGx/FSzkf4kimoRLyTtTUPluaoAoLsxXdM856AGZt8Qx5 jlmHefVMXMNZBr+AFRa2LzUZTfAxdB0BMJIKE5sksfzqjIlBrrC+T5LPuRWEofavWo/3 F/GZDaRnOOhbygsfH0j03xhE3HqoAQG//BV4OxNYxh7oouojeSXJuZuDz6kopw2p4NCf Ynp4e1y8bZ63Waaexky1ngWhsDI6OKUDck6pZKvRx1y+Zn+C9GdyTpMfKg9rM3tp3pR6 05rr0LSExy/1hv6IGzg2LnjgentqEF1YBhE1RSaDxjd/E/3JnIA0opNF1eeKFYk3zNDR ps+Q==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1773652633; x=1774257433; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=hkdTbs5/4oZ1Uw5RYryF5V00ahOj9fKTIU58XFu/vcY=; b=TNkz5lKnAlbrD2+CkTchV7jDbSyBBcTCZfbfQgooltse8dH7/JOwABL1rtmiuLcjC7 cBVxp+qNIUql4l7JitesbHPy+2zWP6iadna0F6SON/W9Hmqwk8Eti+nnpdFhUnS/NWP6 2XaOK9NqjAzctlxykjIhPsfbQDPG/7ADeru76N8mSAvNnKYJzVmK2t4ViR1kz58v/6IF e5Z59Xjn+xswKp+e89Rctcu7R3kWJ5UBuhbGlT19RptcqNaY7J38S9jodheTuEsz4SET wStRKGUXsN72oITQPxILyq3YXzF4+avplYsFpLIdq8aSgUGuyxh2IGwnAJ17JAn8Fqyr 4Daw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1773652633; x=1774257433; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=hkdTbs5/4oZ1Uw5RYryF5V00ahOj9fKTIU58XFu/vcY=; b=YruINt5BpLxnJadCDCyYytzk9h+PrSSTMOWTI3/TkbZSQLaB08uplf8TpBHO0Rfb/x KfbK8PmgtBm1jY0toupdO26jguU9TpAmrqxnDbdWVWlIzwm+wbzXhDyPCM1PVGEurs/7 BFe8gLC56SAJg+9m2G0rgxQqDapmnhknbNIwpJLxrFgtoonsTJoOHFYHLhNR64biJE66 IM5mpi79zCZ0Gv6+JXh/Dah3IWuapU/vgiK2YvcWEmuNzDUEMBoduy9mYfGBUoI8POtP LWOoAIeO6WKw5MkWhcPUWxiNt9He0n35wgNYUKGyelI5ZU5p4hYhHjgXqwg/hKNl47rM ENqw== X-Forwarded-Encrypted: i=1; AJvYcCXP4YXzK/GpzLeBB89Rs98s8QdxrrHL8KbkNOBx2BKVV1bbmnykk8c4qpzWOCXUf9dLAxQvU9MM2YS50pkl@lists.postgresql.org X-Gm-Message-State: AOJu0YwvLKWTHls3BT3s3otvw19XsengrgPvgkOeo6w8yuhSqE5i/7yc cgNLTfqhzg3znV3L7JGeMn2P2eJxbqamCm7U1PRDsf16bqhjEfG6ZUjdvWqrZUkoaydXD0OCywa u/C1lP0e1H27SNAptwcznSMDuzDOLoWQ= X-Gm-Gg: ATEYQzyn21ihWtgrX19b666r2Wd6BH36vitb0FvpVeTXAG6tBqM5pITZ5chIlN6WYnv 0inrTd7oCrblLiOutcCFfMNLSIgVKIAsx4h5CooVIS1NBcakJpBMfssFeuauWwx6hba+1pxJ78q Crc9c9cCdKka8zUsvXG5wDGqFOkDwZ69pXoZvg5tFqUwkT80F21X8XKF8QxPL4gBuO2XSy3NNvb L0iUmTcx0QVJX4slhb0VvcladhJCReZsUEQSTh8ExfFjC5B6vVof4afSpjioqb43Hhc5VqKyrNn 6+zJIB5ixfS/JC4suqwQeTKr1xx/DA/uVgn5tC5sHHqq6PaXhYEHcAWLe14xHNjiwjEsQN34 X-Received: by 2002:a05:6000:1866:b0:439:bf2f:1233 with SMTP id ffacd0b85a97d-43a04d89566mr20631898f8f.20.1773652632646; Mon, 16 Mar 2026 02:17:12 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: David Rowley Date: Mon, 16 Mar 2026 22:17:00 +1300 X-Gm-Features: AaiRm50SsAA9_w9CGLQbq4SV_CC3hN9hax-yhr7HGmMuiauzm6PWoK8fJf_D3wY Message-ID: Subject: Re: More speedups for tuple deformation To: Tender Wang Cc: Andres Freund , John Naylor , PostgreSQL Developers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 16 Mar 2026 at 20:01, Tender Wang wrote: > SELECT * FROM t2, t4 RIGHT OUTER JOIN t0 ON t4.c0 WHERE t4.c1 ORDER BY > server closed the connection unexpectedly Thanks. Looks like I didn't get the startAttr logic correct in nocachegetattr(). Starting by using the attcacheoff of the first NULL attribute isn't valid. It should be the attribute prior to that one. I'm just verifying some code locally now. David