Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pSKUU-0004wr-L1 for pgsql-general@arkaria.postgresql.org; Wed, 15 Feb 2023 16:18:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pSKTV-0000m4-ID for pgsql-general@arkaria.postgresql.org; Wed, 15 Feb 2023 16:17:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pSKTV-0000lu-5N for pgsql-general@lists.postgresql.org; Wed, 15 Feb 2023 16:17:41 +0000 Received: from mail-oa1-x2c.google.com ([2001:4860:4864:20::2c]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pSKTO-0006VP-LG for pgsql-general@lists.postgresql.org; Wed, 15 Feb 2023 16:17:40 +0000 Received: by mail-oa1-x2c.google.com with SMTP id 586e51a60fabf-15f97c478a8so23443556fac.13 for ; Wed, 15 Feb 2023 08:17:34 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=oJVA57ugMTOzWqDcOd0T6zEHSM602nwoU2tIrHsISKw=; b=OXDMI3k/jDj1qLJIJfLim477mTrTLP82gD94SP8sV6O2ELyXKUJQp54M4jInifdAFS 5o47wLEqWXgKvCEDaXL18X4jY10tbsMCqtLIHfY+OuzasjAXKNDeWxaJnwNvr47dsXjJ OgRPeN0mYx5SW+3eyT/Qn9bMEqRAyDaZD6cM1HRXuEcgleSCeA2Q/EKkzMd0kNuvRqWp E/0SXr0LZ+eA3/lsVqnP7YftLqOYeFKLhOGHySlQkvb/L6s8qEsFZIF0URJTvwshJK1d yARQyFFEYuESV6pTuZjU19tKZpZngHKrQJBbwo9a02ERptxzf1ey7pEq1wbGi10RsE6z ngHg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=oJVA57ugMTOzWqDcOd0T6zEHSM602nwoU2tIrHsISKw=; b=DVBR1w5zdYN2SrppKRu3M6Wc64oW+5SwI3PkSuxC96/R73sHpuwzpYNwIy2ybwL4Lp ly2m7ahE9QLpqYYOJH1J6pgv5EUUZw026Ubz7q27yNbAobdE/o67nOj28ua46T6HpCpI rZIBCiYmL/DCYMJeVkZcM47tzO7HRGioA2A28NybX4AuDOG/UJqWxJtTQjcJDhIJ0l6h P1qObuMjWgyJ+aI77gajoQtzwmvlGb/vFq/yyA9qB7Br6I0gwujYv+vyAo8X+P7yRc8m Pp9SSJ2TTqOrfLnSvXF3orVw4g96eF04QNSGP595cpNaes5oKDVC4Nnp9v1UT8mXANx+ IjAw== X-Gm-Message-State: AO0yUKVM9CaagHuWOV4Nkjk7wCXZ9HEXP7GzkP5E5YxR0+FA2RMeJp/q Z+YOV7SiwWeFIjdXdys5yO92Hg+F0n8= X-Google-Smtp-Source: AK7set//VYIY39nhrU+1mUlOkATrReWxhlBtlB9yKPnD2jD+yoRsNePgRxC5db2wdXkswQKE+NPq3A== X-Received: by 2002:a05:6871:151:b0:16e:1c9e:3f34 with SMTP id z17-20020a056871015100b0016e1c9e3f34mr1378319oab.6.1676477852037; Wed, 15 Feb 2023 08:17:32 -0800 (PST) Received: from ?IPV6:2600:1700:bd2c:b810::43? ([2600:1700:bd2c:b810::43]) by smtp.googlemail.com with ESMTPSA id ec22-20020a0568708c1600b00143824af059sm7179230oab.7.2023.02.15.08.17.31 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 15 Feb 2023 08:17:31 -0800 (PST) Message-ID: Date: Wed, 15 Feb 2023 10:17:31 -0600 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.4.2 Subject: Re: Query plan for "id IS NULL" on PK Content-Language: en-US To: pgsql-general@lists.postgresql.org References: <20230214223917.xlkhp4yspwhsxvgu@hjp.at> From: Ron In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2/14/23 18:21, David Rowley wrote: [snip] > since it likely only applies to nearly zero real-world cases Are you sure? -- Born in Arizona, moved to Babylonia.