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-hackers-owner+archive@lists.postgresql.org>)
	id 1qqW0M-00AjAW-Bq
	for pgsql-hackers@arkaria.postgresql.org; Wed, 11 Oct 2023 09:59:50 +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-hackers-owner+archive@lists.postgresql.org>)
	id 1qqW0J-00Enh9-GU
	for pgsql-hackers@arkaria.postgresql.org; Wed, 11 Oct 2023 09:59:48 +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 <s.glukhov@postgrespro.ru>)
	id 1qqW0J-00Eng2-6S
	for pgsql-hackers@lists.postgresql.org; Wed, 11 Oct 2023 09:59:48 +0000
Received: from mail.postgrespro.ru ([93.174.131.139])
	by makus.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <s.glukhov@postgrespro.ru>)
	id 1qqW0C-0016gM-Ah
	for pgsql-hackers@lists.postgresql.org; Wed, 11 Oct 2023 09:59:46 +0000
Received: from [192.168.1.3] (a0.sub235.net78.udm.net [78.85.235.0])
	(using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits))
	(Client did not present a certificate)
	(Authenticated sender: s.glukhov@postgrespro.ru)
	by mail.postgrespro.ru (Postfix/587) with ESMTPSA id AA1A0E20EA3;
	Wed, 11 Oct 2023 12:59:37 +0300 (MSK)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru;
	s=mx2023; t=1697018377;
	bh=uGOcWVjpiwRL+yAn3qLke0FTS5LkbemuBEkz40mp15Y=;
	h=Message-ID:Date:User-Agent:Subject:To:Cc:References:From:
	 In-Reply-To:From;
	b=boqXrcv2jbC3wqnYXcTR/Fx27zH0mMdh8O99vGiKSFQAdvHI+QnQ6r0U6VZPDjV+B
	 5eYofy8gdwGMpv4kP0tWmyjdnpy4vJ8z9nGzggMFBVWn2pwe1ZkZf9t6BXq/vSITf2
	 PqrA8zAWmJfEMnFR0XkhFJJSZ5UZSARDv6lTvhnbbj340jEwO12K0CM0teBeZaQEyR
	 m4leUZH6aqE4dgbObeFNRgtLOlzAOEIsigHz3yYXQ2/4SiWmAu1v1gzL6mM22n1aD6
	 4CdUoGEVKuGiPW59lplVC+syqH8Q9FpKlRtKiD6nre2VOgSPiLR/qf9DnTc91Rc4/m
	 h++UY5vw8pHkg==
Message-ID: <f1308762-98cd-a5af-b8c5-c6b9ec3c0599@postgrespro.ru>
Date: Wed, 11 Oct 2023 13:59:37 +0400
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.9.0
Subject: Re: Problem, partition pruning for prepared statement with IS NULL
 clause.
Content-Language: en-US
To: David Rowley <dgrowleyml@gmail.com>
Cc: pgsql-hackers@lists.postgresql.org
References: <d05b26fa-af54-27e1-f693-6c31590802fa@postgrespro.ru>
 <CAApHDvrc8BjkN8U3NUVzvat3EtC7bzLwFdUw_OFf3Sv-QCp-Vg@mail.gmail.com>
 <2f09ce72-315e-2a33-589a-8519ada8df61@postgrespro.ru>
 <CAApHDvq2gjyqkn=h95kFqRrTKUorrb9ab0bMoQnEua-v6p5Pcw@mail.gmail.com>
 <CAApHDvpf2VU4JHEBfXJsHF1Aq=+aKbtfKx3dtsZudOKLF2wu7Q@mail.gmail.com>
 <5845262d-9b6a-71f7-3485-c06e4977586f@postgrespro.ru>
 <CAApHDvovhSB8WkhZt9Y75w7+qvemXufkd4MvbNHf9jwjn3M9sw@mail.gmail.com>
From: Sergei Glukhov <s.glukhov@postgrespro.ru>
In-Reply-To: 
 <CAApHDvovhSB8WkhZt9Y75w7+qvemXufkd4MvbNHf9jwjn3M9sw@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/f1308762-98cd-a5af-b8c5-c6b9ec3c0599%40postgrespro.ru>
Precedence: bulk



On 10/11/23 13:19, David Rowley wrote:
>
> Thanks for having a look.
>
> Unfortunately, I'd not long sent the last email and realised that the
> step_lastkeyno parameter is now unused and can just be removed from
> both get_steps_using_prefix() and get_steps_using_prefix_recurse().
> This requires some comment rewriting so I've attempted to do that too
> in the attached updated version.

Thanks, verified again and everything is fine!

Regards,
Gluh