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 1seOnO-006fXm-FG for pgsql-hackers@arkaria.postgresql.org; Thu, 15 Aug 2024 00:56: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 1seOnM-00Dj5M-4P for pgsql-hackers@arkaria.postgresql.org; Thu, 15 Aug 2024 00:56: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 1seOnL-00Dj5E-Lt for pgsql-hackers@lists.postgresql.org; Thu, 15 Aug 2024 00:56:51 +0000 Received: from mail-pg1-x52c.google.com ([2607:f8b0:4864:20::52c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1seOnJ-004mcr-7j for pgsql-hackers@postgresql.org; Thu, 15 Aug 2024 00:56:50 +0000 Received: by mail-pg1-x52c.google.com with SMTP id 41be03b00d2f7-7c68b71ada4so387406a12.1 for ; Wed, 14 Aug 2024 17:56:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1723683408; x=1724288208; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=gV82cfxtR/NuZ9FXR4BmtRhNZA1zbM+2k9jWz+JnogY=; b=T805UWXy/r8dC7O9svsGB5hIe/QMSd6K/By3c9Lkjh8r0hpZQHQPyZV/atyhUjxab/ 3OcjCmYMZPDCmFEAlK5aJryIqsw2+gLTCE16aCL7fYIJx272gM5oSb7HiZtVnXoMq2kf CiLHMsGelkJ4E2PPHvHrprYUOZ1UwAZIJz7EEWhUXNu7OZeUOLPxgWPpGFyPHK2aITBc UtX+7IRV60LiaVQx6qD8PZTA+2E10ukAe7vK9UuOD3sgnfwKo75naK8497MMzRgQag/o eiA3+sUErq14xaMIvpVZqWH5L9mW3LjaYp7+6VST6myVOsLfB0/7TTYO4bo4Rr4CHGjb f1ZQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1723683408; x=1724288208; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=gV82cfxtR/NuZ9FXR4BmtRhNZA1zbM+2k9jWz+JnogY=; b=FCVwlMGyGpvwxs9JaZG24qvSf8yHbP19FHMtPNh28IJdfSjYh3Ue8x9sgVOz6nWgLJ VS+Aq08RU/lk6UpefeNFBCO9kol+myWKpRPr0wRSV6zoCJbtMyy9zssz7kaOgL3aenup 3qz6r93QAaLi0kp3lR7zoPYO7Q1C1ymN53tzkxdaeVbjQzF+8ls2lk6EVpIeKPBDLyeG 2CeSmJfa1Tq818i195MPN9FHEZSXxd78oVOswFe2YIPplJ8zFwoph13bLX3A3mkKnTWK b20Qf8kbnEYXd6vyt7iZQ7f/buT+cplETpJRV0x31BYoSAUCLHRHoRO8Gv/kMsDBTM4a p6Xg== X-Forwarded-Encrypted: i=1; AJvYcCUh2G7FHs3rwOkgeKEnQ6e5yKd5khqqtnoTnXrSkD0m1sdkWJeRkTcJ4g2L3Rpj616EmRthf6vdn/iUhvh71JnPpzmXMRslWtvgJh5p X-Gm-Message-State: AOJu0YxVAkNlXhRHEBD6n7rrhKeNL9cm/H2TeZxTBDKpnlN74afDYVRE lJ8FFfnY7Sd9k5NlYTTC4uhCzgaejhDLhvN638hZww2P0ghu84qD6nj3rT0FNQ== X-Google-Smtp-Source: AGHT+IGJ3yMj2Lz6Plc3jlvyPYwUbo8a+s2/RCMCX/hqySt1FzA9pjijYiARAM/m9AYMadDsdWrRYA== X-Received: by 2002:a17:90b:3598:b0:2d3:cb16:c8e with SMTP id 98e67ed59e1d1-2d3cb160d99mr166287a91.43.1723683407941; Wed, 14 Aug 2024 17:56:47 -0700 (PDT) Received: from jeff-laptop.lan (c-76-102-242-158.hsd1.ca.comcast.net. [76.102.242.158]) by smtp.gmail.com with ESMTPSA id 98e67ed59e1d1-2d3c879bb80sm266406a91.33.2024.08.14.17.56.47 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 14 Aug 2024 17:56:47 -0700 (PDT) Message-ID: Subject: Re: Skip adding row-marks for non target tables when result relation is foreign table. From: Jeff Davis To: Etsuro Fujita Cc: SAIKIRAN AVULA , pgsql-hackers@postgresql.org Date: Wed, 14 Aug 2024 17:56:46 -0700 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4-0ubuntu2 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 2024-08-09 at 17:35 +0900, Etsuro Fujita wrote: > I might be missing something, but I think the extra round trip > happens > for each foreign row locked using the RefetchForeignRow() API in > ExecLockRows(), so I think the overhead is caused in the normal case. Is there any sample code that implements late locking for a FDW? I'm not quite clear on how it's supposed to work. Regards, Jeff Davis