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 <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1tgPaE-00ARTy-RQ
	for pgsql-performance@arkaria.postgresql.org; Fri, 07 Feb 2025 14:43:55 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1tgPaD-002915-UC
	for pgsql-performance@arkaria.postgresql.org; Fri, 07 Feb 2025 14:43:53 +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 <htamfids@gmail.com>)
	id 1tgPaD-0028w8-K6
	for pgsql-performance@lists.postgresql.org; Fri, 07 Feb 2025 14:43:53 +0000
Received: from mail-io1-xd31.google.com ([2607:f8b0:4864:20::d31])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.96)
	(envelope-from <htamfids@gmail.com>)
	id 1tgPaB-003miF-0z
	for pgsql-performance@lists.postgresql.org;
	Fri, 07 Feb 2025 14:43:52 +0000
Received: by mail-io1-xd31.google.com with SMTP id
 ca18e2360f4ac-84cdacbc3dbso157828639f.2
        for <pgsql-performance@lists.postgresql.org>;
 Fri, 07 Feb 2025 06:43:51 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1738939431; x=1739544231;
 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=Hd32aEx3dN7yYpXm1aOJxj3e2OFWxY0exHA9cvFXN80=;
        b=YqrfY5oZvsSuMIRUZFTFMheqw2+pQPKqoCLrjFf3cKY5BXqkwRlRn4VFYKZ1UXW/6M
         BVyQ4cjK+twzFhCfT9hLMIA7i8egUV8JajomvQw3TCoxBJ0WHQF4CK7fqqvE1i+GxONB
         sOxl1W7d282+CXwjytBBTG6jinC4cS3/9YzUUl17qAHzk5tYykWkN/NkV793yF8GZAj+
         jXhGm3Hjd4NkbLecncgFELxVzU2nfTz/qnWMs+KLZazOmEZAPfX9ZGINyGn1WaLc67dp
         9tT04MQwhLalL8EgpBk+yGF5J7ptSPnAoRI6DGIU5rEW/kr/RPmgAJgXBy/oDWNnAhcT
         Ymuw==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1738939431; x=1739544231;
        h=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=Hd32aEx3dN7yYpXm1aOJxj3e2OFWxY0exHA9cvFXN80=;
        b=jnLVBVjRXCxm2Z9eZrV+sJi6M4mdhrIwOS8fHhdNTd00gyZutFpXEDqDGTvsddWB3D
         td9mPbFI6XERgzcXjHuVEMmD9k3QkCqYWaqnJC5kyjy+GMVX+Dp56l98jOJownJjw31a
         LXAhrjbTWjShe+P88Zk/79+Yaghb4aqtXCih59qUTnJhI0ZrSdvMci8rfJ1pNc6sWRS9
         rMxICk1k/LOkbBm1pk+kBXtz2QeJ2NU2sUjgWuoNG1awUyQRV6c/zW9YWtGRnwzxahXY
         W77KtieOmQ+tBUG9wf5FgrylIffBtPnrsnc1Jc0IWnjqOJtXLVf/L8ASYNxFX8Zjax5p
         wkYA==
X-Gm-Message-State: AOJu0YxhEZxmGEJ/JulIDIli6bsoMhscok021h59zMGJQGfJu1rk8bCC
	ha4koOu/HLwBg5iN8iTbxKxCOi9G0h8alJBh70nHvIAwpdyq8nUiYMibvYgMaIy7g4zWc1ApBlD
	dH+tWK9OW4pxVL4E13dU593PzK4I=
X-Gm-Gg: ASbGncu3LEkrYfKKlN6Mn6KTre5CxvK55igHVGh/BbXv1IF+0Xh7wxl0rKo98s7Z5FY
	1yNHqxlxNyfyNEeU8U96wBL5AlLqEV9HBK4qcNs+7P9Y6hsibZOVxkpByc1UOcIM8mEH0Cfdruj
	HJZjuZrJ1fgv6jKrjpJzkIrjvbX0+xIb8=
X-Google-Smtp-Source: 
 AGHT+IEz1nWo+dQeS8zYamXVVwEmorICs/8R0jjQzPI+pE3NUCzfMSH2AkYDCOTmkkvFBkI43pmswcsXjEO+y2HOj2c=
X-Received: by 2002:a05:6e02:1a41:b0:3d0:147a:b5da with SMTP id
 e9e14a558f8ab-3d13de77c41mr27012765ab.5.1738939430966; Fri, 07 Feb 2025
 06:43:50 -0800 (PST)
MIME-Version: 1.0
References: 
 <BLAPR09MB64993673A034EE93C6C6F4B6CCF62@BLAPR09MB6499.namprd09.prod.outlook.com>
In-Reply-To: 
 <BLAPR09MB64993673A034EE93C6C6F4B6CCF62@BLAPR09MB6499.namprd09.prod.outlook.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Fri, 7 Feb 2025 09:43:14 -0500
X-Gm-Features: AWEUYZknCj4PSgBUVadX35Iq69MZ6bwhkfdriL9CUZyAFCEz5mmmAzsXfZD89kY
Message-ID: 
 <CAKAnmmJDHajWWYx8bMUJRxVHZnLnP0WhEMZD40jeqrZ7aLsFUw@mail.gmail.com>
Subject: Re: Poor performance with row wise comparisons
To: Jon Emord <jon@peregrine.io>
Cc: "pgsql-performance@lists.postgresql.org"
 <pgsql-performance@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000011a186062d8e6325"
List-Id: <pgsql-performance.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-performance@lists.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-performance>
Archived-At: 
 <https://www.postgresql.org/message-id/CAKAnmmJDHajWWYx8bMUJRxVHZnLnP0WhEMZD40jeqrZ7aLsFUw%40mail.gmail.com>
Precedence: bulk

--00000000000011a186062d8e6325
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Fri, Feb 7, 2025 at 2:05=E2=80=AFAM Jon Emord <jon@peregrine.io> wrote:

>  but with limit 101, the extra shared hits return
>

Can you show the explain analyze for the limit 101 case?

Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support

--00000000000011a186062d8e6325
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Fri, Feb 7, 2025 at 2:05=E2=80=AFAM Jo=
n Emord &lt;<a href=3D"mailto:jon@peregrine.io">jon@peregrine.io</a>&gt; wr=
ote:</div><div class=3D"gmail_quote gmail_quote_container"><blockquote clas=
s=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid r=
gb(204,204,204);padding-left:1ex"><div class=3D"msg2185234472462564621">




<div dir=3D"ltr">
<div style=3D"line-height:normal;margin:0px;font-family:Aptos,Aptos_Embedde=
dFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif;font-size:12pt;color=
:rgb(0,0,0)"><span style=3D"font-family:Arial,Helvetica,sans-serif;font-siz=
e:small;color:rgb(34,34,34)">=C2=A0</span><span style=3D"font-size:12pt">bu=
t with limit 101, the extra shared hits return</span></div></div></div></bl=
ockquote><div><br></div><div>Can you show the explain analyze for the limit=
 101 case?</div><div><br></div><div>Cheers,</div><div>Greg</div><div><br></=
div><div>--<br>Crunchy Data - <a href=3D"https://www.crunchydata.com">https=
://www.crunchydata.com</a><br>Enterprise Postgres Software Products &amp; T=
ech Support<br></div><div><br></div></div></div>

--00000000000011a186062d8e6325--