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 1w0VZn-001xtt-0K for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Mar 2026 02:15:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w0VZl-00CzKE-16 for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Mar 2026 02:15:01 +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.96) (envelope-from ) id 1w0VZl-00CzK2-09 for pgsql-hackers@lists.postgresql.org; Thu, 12 Mar 2026 02:15:01 +0000 Received: from mail-oo1-xc2f.google.com ([2607:f8b0:4864:20::c2f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w0VZj-00000002EQE-07uZ for pgsql-hackers@lists.postgresql.org; Thu, 12 Mar 2026 02:15:00 +0000 Received: by mail-oo1-xc2f.google.com with SMTP id 006d021491bc7-67bb4e8955aso356092eaf.0 for ; Wed, 11 Mar 2026 19:14:59 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1773281697; cv=none; d=google.com; s=arc-20240605; b=dm4JGWfyvDU/uqN4BxrsKA8ZnDY3SYfihNh5j5zf5rKQOoQx+hnTSaKUlX//vxOLNe zNCYMCc0nqMK8GZ8kGzAMfD46LnnkckMJTxsFU6xfal9R5lq/HNsn07ajiMib7etJ8XU 6H12FXoiKo+AyOQpUhL0FnAxmo2gPZc8yVy51XHYtC0sjXZGIvALtN1qryCMT3qkxm72 77FdI8shrBK39CdlBE+P9vR0MmhQ8CiX13mkeeZqafaLixkMLkiaITPBqyu5JKLc5MOD gqbUjwrJSt83a1QTJcsLtmtYSmtF8SlUr2197y403O0cMTOsKbIfxbpCkgvGouqM74+y sSTQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=V7q72OmQoLeVMJRhUDz+Ium+9tR3DG0/7DcROE4fTNI=; fh=QZA3HatraZtBudnDYlCm30vzRA+QU+vDpqxILDR+iTQ=; b=jKdWwQu4I1lBXf1Vje0wgxWYQoaPX6oW8+8oX2qC5wFDzigXzJJbJflpDutUzpmBtd Cyud6sy5GZFI9PdA6cB8DwqsdbKFx7D26fS0vsksiZ8+5CcqGugDy1CPrZrYJa0PMYlf /uYILMaPyTDhi9d1DumuX0ARoTax7cpHQWAqJ8dm93fxjOw7P8CN2BTHJQCGt8i4lSHq Fy6fsh1xA07MB+Sh3deWi/8AAbxp8X85xNnW1p1p2DoDG/kAj2S6PdWsq0+KqRx8CLGn fDU2MYdTqcx7iwcZtEDJS5a4IobLHWCqakeommClDyp5OjLbR6dQe6ffKXG9xgEaPByX ePsw==; 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=1773281697; x=1773886497; darn=lists.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=V7q72OmQoLeVMJRhUDz+Ium+9tR3DG0/7DcROE4fTNI=; b=lmZh3Cx2SZUfZXyM26BAITqQ4G37j3LkGlOkcjDMarLSjmdNvjSnYk5zcSkb3XSqEn fArg83DM4ZS1oEesUm2dLu/zCM6w9M/igPcMzBndymt1iV9hCcy3Rxdxleuu7jjPJXbV 2Tyt/C1VawvzbHJcCyv5sI65u0MfugnIqp8lQuW5pF7fWoWMHCBnifd7NA5J5OE/3FfA DbQxp+UuxEn3ozVkt0SxIkwtvevCpyZjgIbnoSp7d1N/1AJkQvXbYKVxxOEdkUhvfcQI MmgOQbK3zXhEAbQptv8KsM4jxX21jKG/sKwy5DLbcwtJ92du5uzX9x2Q4sLQYrTuEQqY OcKA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1773281697; x=1773886497; h=content-transfer-encoding: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=V7q72OmQoLeVMJRhUDz+Ium+9tR3DG0/7DcROE4fTNI=; b=Nb2AxmG+yqoPmERg0WIJ/gjJ9GYT6EsWU/m0CTbtrqLbsjIMAyzPT6qFdb6NFjjvxq cZl8PGtQLGMSHvt5v4ggLfOIlQ/WoSbY/B6Aoo4AOgBP0zqgxy5RHV5GalMwAqfNI1kd oL9UKcwkNoLeYjQHIt0Ft9RNzUPt6G7KjNOAjF7fmy0s/YvWZc7nSXbOK+rQ9wylrj/s QGBPVFWVCsEuy8gHmFeekNCAb51zPazxrLKbZOyyEaDe0YUB3ZGe9cmkbcmEQaO7MKTl uLOOiVonkLjtAGmB/UEuJnn80e9fUoQB8QMMY0ue7oO93fsXC6otu6yi/CA3WNYcVe/R s+qQ== X-Forwarded-Encrypted: i=1; AJvYcCXbfYtQhVy4RJECoYvJF9pw9YRa9k/WrA/qvS7zHWXeKcEOTimHB3PqhHor3BZHugJ6OGeM++9pa8R8ZnEV@lists.postgresql.org X-Gm-Message-State: AOJu0YwRtH3j32XmeO9rhIxvj/LK5SOLxQhqggq1ZLemMmp4ZP0ksGl9 RaOCKtvJFLArVDfAqA156NP18szAXbqAh37tX+jzjhuYvJ+FXCUi76vDf1PnUqgAqmO5IFLIlLZ SlFoYHvJXvgf0RPlJkk1upBu8g/DKCs0= X-Gm-Gg: ATEYQzy0RWiXEkJXfGxEiNArMifX7aMYUlYaeVWdgVOajAlkD11C+3666gy7SEc2uW8 Hqekj61nOAE/cMxD7fOea3soIPElQa0nF2ZY6M5+Vq/KI7hfNalFIH2VoMX5YPxBKcsaZF9JGkO jYNgap8g6U+Gm9HXs1ON2bDU8bR7N0O5FsPkm9M0+I5gI9ppxQXJ2mc5AXb9msnnGG6B+fXS7Y1 Szf20AwpXiZyFu0/Fvin97TqlxxoUQOhiukxkffSpcwfOjl3o3l0X3qi6krylAcJJfhuhrZ8Hnw zdRgZdgeZd+O7gPQmJo= X-Received: by 2002:a05:6820:290b:b0:67b:b554:3931 with SMTP id 006d021491bc7-67bc8873b00mr3141661eaf.10.1773281697361; Wed, 11 Mar 2026 19:14:57 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Richard Guo Date: Thu, 12 Mar 2026 11:14:46 +0900 X-Gm-Features: AaiRm520s3IpBUeS80XLpIyDGxLEs9sl-MifGsKPM0x5WZl2RIoTDtNOjs8NKSA Message-ID: Subject: Re: Convert NOT IN sublinks to anti-joins when safe To: wenhui qiu Cc: Japin Li , Pg Hackers 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 Mon, Mar 9, 2026 at 4:38=E2=80=AFPM wenhui qiu w= rote: > Thanks for updating the patch. v6 path LGTM. Thanks! Committed with a few minor cosmetic tweaks. - Richard