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 1vJXzJ-00Ad6T-01 for pgsql-general@arkaria.postgresql.org; Thu, 13 Nov 2025 14:07:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vJXzG-001nsV-1X for pgsql-general@arkaria.postgresql.org; Thu, 13 Nov 2025 14:07:46 +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 1vJXzG-001nsN-0L for pgsql-general@lists.postgresql.org; Thu, 13 Nov 2025 14:07:46 +0000 Received: from mail-il1-x12e.google.com ([2607:f8b0:4864:20::12e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vJXzD-007YAF-2Z for pgsql-general@lists.postgresql.org; Thu, 13 Nov 2025 14:07:45 +0000 Received: by mail-il1-x12e.google.com with SMTP id e9e14a558f8ab-43320651e53so6787045ab.3 for ; Thu, 13 Nov 2025 06:07:43 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1763042862; x=1763647662; 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=D5v8wL3gPKyxDBA0qV/1XNxD2L70tMzV+4cto3ysK+k=; b=AOmjztB5yxN7sr9s6JtlDTF3waUd1i4D25ZTcLThJEEuUyqfahUudPFmeYqB3v+tql jYsM5XwNHYmPbIhTFLPLQvsILWZR6lKYpdmuY7r2EjVImbStcHzx2wY57qe8iyGZjc3P 01zQlnj8IeQyhbsPqAHkG0MEsMwEIwmdDzVU/GBaAsgOSJTAxe8sESH+oW7MsVwfgmxh prYwRjmBicEmX89/BPiHefYcTgDyT55ePzrPL60ntH+J9Ia52iF5rT2t9YpjEcMSM9TL FyZA9JpyxuNLp7kbZH5KOUNpaV5ioGB3RaRRbxCDps9whEX1hbodlm994ei/AkoWqLka EVXg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1763042862; x=1763647662; h=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=D5v8wL3gPKyxDBA0qV/1XNxD2L70tMzV+4cto3ysK+k=; b=CkaqgY0EApZEarG7w79CqT3vS24518+63QdFn5E48+eOVgimFTUFnLTpdHHy9jEQ2m wWRJ+1wGmiqXXLmhh/wl5qMaHnoI37UD4PhfHOH4udzSRfJTcAnPdlKYVj+eTDse9dHg Swq6DdUMjcSL8FRXZkmcdVoNdRc9Htz60msGCSEwJiIuR+x7JkrKAKhQbXwiR1RIpKdz rUGBc8JFSbHeWq6H2cvoP5OW2bTkHhuOBsccXRs133YI880VzkuA75/gWZbUqQuA6dr2 DVo63Dcb3iu31VjBsNxqtVJA5HVeQB0NeKvzL2ldDJPnrZeXXFYDiIBcw2rE9KZAsovh r8aw== X-Gm-Message-State: AOJu0YxO179WLK00TiY4Ze45adidSyFWvRvjFmoBZsflplVsemoe0PFd M3B/GyRSrzlWzaVNSghjbNa6ITj0xm0HJFAL8V3KYT4AfnNk0/ni+AHSyaJRzVFl8EeQUnP+cdq ZtC+gRSWZPtgSP3c4nlQ9SEnM4bZS0hw= X-Gm-Gg: ASbGncuygOkRDf0QWj/zqaazxG415pCEwFuNVn/ScKUdJwRBnR8J0ehF+CGm9ZqWPK0 tOilVJO3bnxWzQu4NL7WczXB4DdJ9YbR7SM6LCPW42gZORqsB1CdgAqSCwcUTCJaHmfosOwqhoa nTKoCDC2A2LWXPIFjiEjzz+r8hG7LLYZ/wjootWrBDJ0UQ9bUvB1jFc3T/1XCcLXkolnzy34cFH CGu9cQbf+BI9F5Jlz1Z7Y0MqtBGYpMFTFamvA7Q3wlhzB+xRL9FxzP2btm3Ee7XveSusudB4cRs J29igj1V+i4cY8PLFDw= X-Google-Smtp-Source: AGHT+IGfms96SMZLP65fFfZwAgxXwKtBjeq1XeUsKBkL1RSO4HAtTtj6ANFXBsaPryH630n816KvW3/xY2J3SjQUUdU= X-Received: by 2002:a05:6e02:380f:b0:434:7a8a:3e0 with SMTP id e9e14a558f8ab-4347a8a0685mr59612455ab.1.1763042856532; Thu, 13 Nov 2025 06:07:36 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Greg Sabino Mullane Date: Thu, 13 Nov 2025 09:06:59 -0500 X-Gm-Features: AWmQ_bkDcOevxIWlUJFKKNdYiukr8c39qVsiKJfwGF5S9lFkZH9Up_o7tpMdDsw Message-ID: Subject: Re: Forcing Index usage To: Zahir Lalani Cc: "pgsql-general@lists.postgresql.org" Content-Type: multipart/alternative; boundary="00000000000030253106437a67b4" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000030253106437a67b4 Content-Type: text/plain; charset="UTF-8" Please provide a self-contained use case, or (at the bare minimum) trim out the irrelevant parts of your query and show us the schema for the tables in question. Finally, please show the explain plans for the "good" and "bad" runs you are experiencing. Thanks. Cheers, Greg -- Crunchy Data - https://www.crunchydata.com Enterprise Postgres Software Products & Tech Support --00000000000030253106437a67b4 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Please provide a self-contained use case,= or (at the bare minimum) trim out the irrelevant parts of your query and s= how us the schema for the tables in question. Finally, please show the expl= ain plans for the "good" and "bad" runs you are experie= ncing. Thanks.


Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support<= /div>

--00000000000030253106437a67b4--