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 1tmZo1-007mHx-Ut for pgsql-general@arkaria.postgresql.org; Mon, 24 Feb 2025 14:51:38 +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 1tmZo0-003XoC-Rd for pgsql-general@arkaria.postgresql.org; Mon, 24 Feb 2025 14:51:36 +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 ) id 1tmZo0-003Xns-GN for pgsql-general@lists.postgresql.org; Mon, 24 Feb 2025 14:51:36 +0000 Received: from mail-pl1-x630.google.com ([2607:f8b0:4864:20::630]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tmZny-000YBY-0a for pgsql-general@lists.postgresql.org; Mon, 24 Feb 2025 14:51:36 +0000 Received: by mail-pl1-x630.google.com with SMTP id d9443c01a7336-220d398bea9so70419365ad.3 for ; Mon, 24 Feb 2025 06:51:34 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1740408692; x=1741013492; darn=lists.postgresql.org; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=BCIge19MD0gHzlp54JzKziKvKuelAmDYtYcvjUYYLHM=; b=UFijBLasxqEGWRwiKA3D3EdFtMPzUDvkOEX+aqw0PSVVnn8Cxk9z8LfK/ow1bz2A5v a7HK6uce7V3DK+xowcGrdqnlx9z0EWBuO1mf5O6IPv10YNNUfH2cnDbUNGlul1qTrwn3 sGlGKZaL63hnTaWZ5Tg2M33DvqhuZxH1cVrR2ftIWExjYgS/pUJuiH7E2OkACKeBpEmv H+uoj+LBcaztLX8DnMN8OQzZpxfw7Q+ijgWmc7aGjcwejG3uCE5DSf8QnFsd+YB2M8LG qAQbVG0aSkmych6KtWMTikCsKI3AXXgTQfc7Wi7KlNJjK78ojX6VPlG5GtHYYUm7fO6P KL0A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1740408692; x=1741013492; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=BCIge19MD0gHzlp54JzKziKvKuelAmDYtYcvjUYYLHM=; b=nwcB+2RUgG9aPylS+vqe35XBYoECY+0hFwvH7M2eEF4ZaFt+qVwfnJvsObGN2L7xR6 bozaKWOQ9e8uYzx6TcplqAd1lJ2oKs8OdJRkgBsExah47J1K1BMfyoCKW02yQbJSrLvC BvOdw7ILVBqvan7YzlBwTFlMlVfzdtIjLC7ubRUyXjWCrq60XO1j0xW3v2zA4Zju/YFn WnmXJon/law+oeury/fSXtreUZ6vF4xsfVGHa6n/+dyOOMXfEzTwUaiWWK7H2lQ7BJF7 lEmccJdlOsXuttUOy+Kl8L/6tej7OHDlJX6FnEgGfcHEZ+7Wv1ujIW9qmZx2IyRMmZpg eE0w== X-Gm-Message-State: AOJu0YwwYxZ75v9C8roLb+hpV+GJkj8hi0jC4op74Fo+8yC0dcvz9x3B 8sYFxZNUO2vxPN03xje++HfURlnXHC6htYrsP4I6HqYZfq3+JFfvk7tbRA== X-Gm-Gg: ASbGncs09p+WZOERmjZ9SslBerXqW79o1zAF7iFeIO3Q9kb3Ysurc2c14k35DjGyg7J lJz8ZYrX9/IoXt9NOe70X+sR4qvymA+S93gHKHIkpCPnfdtiWCWqI6NT6x8bIDwaJseb1dOpeoh ZMN7BQrm3KqGfukymd+73Oxh0usvnJmDgqjsT0zS5L1Osi3UyeX+cHrXCEHDkojbij5jWhiX703 LH61B8b/tLt+nScHEKqLp0M9iNf9f4UaTXjHlAiJW8Nl0jPjyMm0lpxCxr78CqcLkl6Ue2a8HBQ lla99P1hDksurbfA8GRt3/R+QrmAYGmfoZEQLeT5Qrzhlt4HI10ErWw= X-Google-Smtp-Source: AGHT+IGRezL8pXVQR8QcE7RLoYamhnQef0JZgSHWyxtFbrZ7f/QS6mZpCjCHnY3CCC0azlRr3fhKuQ== X-Received: by 2002:a17:903:32cd:b0:220:c813:dfce with SMTP id d9443c01a7336-221a1191954mr206775475ad.39.1740408692261; Mon, 24 Feb 2025 06:51:32 -0800 (PST) Received: from smtpclient.apple ([2601:681:4c01:7310:f145:3f98:784c:2b11]) by smtp.gmail.com with ESMTPSA id d2e1a72fcca58-7326bcd94fdsm16914846b3a.53.2025.02.24.06.51.31 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 24 Feb 2025 06:51:31 -0800 (PST) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable From: Rob Sargent Mime-Version: 1.0 (1.0) Subject: Re: Keep specialized query pairs, or use single more general but more complex one Date: Mon, 24 Feb 2025 07:51:21 -0700 Message-Id: <07937066-0DE3-4C83-8B86-35DF072C9EDD@gmail.com> References: Cc: pgsql-general@lists.postgresql.org, andrew@tao11.riddles.org.uk In-Reply-To: To: Dominique Devienne X-Mailer: iPhone Mail (22D72) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk API: > * The first type never relies on fuzzy-find. Then have that app type use the simple, fast query. After all each app/code i= s making an explicit choice which yesterday was the same and tomorrow will b= e different.=20