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-general-owner+archive@lists.postgresql.org>)
	id 1tmaMn-007qsW-OO
	for pgsql-general@arkaria.postgresql.org; Mon, 24 Feb 2025 15:27:34 +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-general-owner+archive@lists.postgresql.org>)
	id 1tmaMm-0041by-FE
	for pgsql-general@arkaria.postgresql.org; Mon, 24 Feb 2025 15:27:32 +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.94.2)
	(envelope-from <ddevienne@gmail.com>)
	id 1tmaMm-0041bq-4K
	for pgsql-general@lists.postgresql.org; Mon, 24 Feb 2025 15:27:32 +0000
Received: from mail-oi1-x22e.google.com ([2607:f8b0:4864:20::22e])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.96)
	(envelope-from <ddevienne@gmail.com>)
	id 1tmaMj-000YV4-1z
	for pgsql-general@lists.postgresql.org;
	Mon, 24 Feb 2025 15:27:31 +0000
Received: by mail-oi1-x22e.google.com with SMTP id 5614622812f47-3f3da35555eso2552197b6e.1
        for <pgsql-general@lists.postgresql.org>; Mon, 24 Feb 2025 07:27:29 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1740410848; x=1741015648; 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=g3N8fRhNlMkQRBhkJUcYxa1J/48BGVI9/skCJ1hCZdM=;
        b=TY0+iocxdBzuC+bzD97VypfbszfuKq0DW+aViEeeXYu31vHVwzSRnoeAvF/q1Q1WYm
         Ix7Kecrl3u3FQpiCbK9WOEUToFtfhW3vkSflcRDG8IZXsfhaUEOoN/7h3jnDw6gvdNEG
         Y57eLV7CYqIl9KWnsccYJMlkhJcFO9M6i/Lpm/abqephk53LBezuBAO7OuPZehA5hQkV
         lM/D6yRNUG/QBofc9Ifh6D3JA64jxzW6ppflmKwBNrUOnlR4cqCNvdQWvTuN4a7AAe4m
         4NNYncUmzsT1ZmvO01ERvIXf7R1igXhX1tXWghJ+O4Mmnf42Te7DR4pYSf36yIukyLt1
         igRg==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1740410848; x=1741015648;
        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=g3N8fRhNlMkQRBhkJUcYxa1J/48BGVI9/skCJ1hCZdM=;
        b=kl0lrgE7qXQuRaRfoOYP8BcPW4o/GP/AgJ7n35ogSBtPIw0C4koaWW9rnbQugz6ChP
         BDBFOeLByLGKY8gkMkNGvvRDapLx/aNqzFVnge6LbV1Ndsjf4XQeeh99J9zHi1YyUoys
         cRzUcl7L3+OrlcS0TNg8V5y0/8ZVZeEX5ANE2oGqDOG3ZP/l3AOriio0w8EPP9s2gIWF
         j04dALr/qfMPDRYosVfPbfkP3Ij1dfKOp1L4w0NCopjz4Owa3r/6mytXuMzvVk4Qfiby
         tb7M2FlD1KoW5vyd/TMUtWc4dQaPdf1f2ZCdngyzBUD9cQlT7+z3f+X+sq1B6CKYFFL3
         vbcQ==
X-Gm-Message-State: AOJu0YyaFN2ek5kQgOVFUmvDSLq7tDqRtWZfeW2ljs3FRIW1g6w5n9am
	hfJyCqYG8aGe0cORgh8dZSVD5zoDSag1G6owGbSsFfn2QtO5wtSt2Xnv5EEQhdFLZ6zjc4rHfdn
	ZI3h3PWh19hTYxoCqPBVFdnW1WB0=
X-Gm-Gg: ASbGncvNsYJ3tgVSF9cSdLyFcl+7pOqDRY3hSVuzyXFAM9loZ+E0mC5y8YD1YauEI4E
	fIU4lzJH2f+w09dODICphajDYn9UFDsj370nqBYTzp3hnN58lwauQOIkoPoe0FiBNO/8rcKvMra
	IakXESrkyN6Q==
X-Google-Smtp-Source: AGHT+IGxlouY0mnR6tLxpyrQBZm0FTGzohbRN7yE+WefSAFiDhdTsHVYHJiP6BYYEdFwu/voBjTLte+eUBNlNrZ5ygM=
X-Received: by 2002:a05:6808:10c7:b0:3f3:ffde:7729 with SMTP id
 5614622812f47-3f4246c129dmr11257033b6e.11.1740410847985; Mon, 24 Feb 2025
 07:27:27 -0800 (PST)
MIME-Version: 1.0
References: <CAFCRh-9SDUvcrF_RigOzXsbOm=8mHmzy2OSC1ejQNcjmfXXM_Q@mail.gmail.com>
 <07937066-0DE3-4C83-8B86-35DF072C9EDD@gmail.com>
In-Reply-To: <07937066-0DE3-4C83-8B86-35DF072C9EDD@gmail.com>
From: Dominique Devienne <ddevienne@gmail.com>
Date: Mon, 24 Feb 2025 16:27:12 +0100
X-Gm-Features: AWEUYZlLgNDkzUJcHuge0HwHpIC97m5hFnjDlfkOe4jSwtf2DCyyQuZJr_gYdpU
Message-ID: <CAFCRh-87cx1SYPt+S7xP+trz=yX77HECGokYOije-MLK0u+chQ@mail.gmail.com>
Subject: Re: Keep specialized query pairs, or use single more general but more
 complex one
To: Rob Sargent <robjsargent@gmail.com>
Cc: pgsql-general@lists.postgresql.org, andrew@tao11.riddles.org.uk
Content-Type: multipart/alternative; boundary="0000000000005b888d062ee4fac6"
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/CAFCRh-87cx1SYPt%2BS7xP%2Btrz%3DyX77HECGokYOije-MLK0u%2BchQ%40mail.gmail.com>
Precedence: bulk

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

On Mon, Feb 24, 2025 at 3:51=E2=80=AFPM Rob Sargent <robjsargent@gmail.com>=
 wrote:

> API:
> > * The first type never relies on fuzzy-find.
>
> Then have that app type use the simple, fast query.
>

I'm sorry, but that's neither helpful, nor relevant. --DD

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

<div dir=3D"ltr"><div dir=3D"ltr">On Mon, Feb 24, 2025 at 3:51=E2=80=AFPM R=
ob Sargent &lt;<a href=3D"mailto:robjsargent@gmail.com">robjsargent@gmail.c=
om</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container"><bl=
ockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-lef=
t:1px solid rgb(204,204,204);padding-left:1ex">API:<br>
&gt; * The first type never relies on fuzzy-find.<br>
<br>
Then have that app type use the simple, fast query.<br></blockquote><div><b=
r></div><div>I&#39;m sorry, but that&#39;s neither helpful, nor relevant. -=
-DD=C2=A0</div></div></div>

--0000000000005b888d062ee4fac6--