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 1unPU8-006bqO-Rk for pgsql-hackers@arkaria.postgresql.org; Sat, 16 Aug 2025 22:34: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 ) id 1unPU6-007MZm-54 for pgsql-hackers@arkaria.postgresql.org; Sat, 16 Aug 2025 22:34: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.94.2) (envelope-from ) id 1unPU5-007MZe-Ro for pgsql-hackers@lists.postgresql.org; Sat, 16 Aug 2025 22:34:46 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1unPU3-000EaY-1p for pgsql-hackers@lists.postgresql.org; Sat, 16 Aug 2025 22:34:46 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Transfer-Encoding:Content-Type: Mime-Version:References:In-Reply-To:From:Subject:Cc:To:Message-Id:Date:Sender :Reply-To:Content-ID:Content-Description; bh=riByj3Cgyk8GmbU60SsoZQFT/s6d/ZidOIkxkGNG+ks=; b=nsSgnQidnnRGY7eahC5G/6oPDY aDUy4eRrqvsvmChK8FRwhLvYT/8JC4sorySk7fh021nUXT7yWx95vaE0opOYO7Kou9SuU5Ku4/jMe B1Pmo0K0Xg43L0RClpiU6oTv8v5A9oo4ZWLm2ZeKs+jT+vCSt09y0sfEnZdWwNgy6pz9mmqKVlqQ3 YyAZZ255DoeWeVPzm1lcGHE5fCyXUKCTf3SXl6nQqOSlh865KNxQAkkBqbB7oa+TEWtRUTeVAeOty x7tihMgWH08BZjHHZpizngam3AfkHn0/ZkbqDqYTQ6eLSqya0Se9FP4oarkDJf2iMQceBSELa+530 rDMNZpEQ==; Received: from [2409:11:4120:300:74d1:78e4:8d18:edb7] (helo=localhost) by meldrar.postgresql.org with esmtpsa (TLS1.3) tls TLS_ECDHE_RSA_WITH_CHACHA20_POLY1305_SHA256 (Exim 4.96) (envelope-from ) id 1unPTt-000Re1-1m; Sat, 16 Aug 2025 22:34:36 +0000 Date: Sun, 17 Aug 2025 07:34:19 +0900 (JST) Message-Id: <20250817.073419.2059765684984047460.ishii@postgresql.org> To: ojford@gmail.com Cc: krasiyan@gmail.com, tgl@sss.pgh.pa.us, vik@postgresfriends.org, andrew@tao11.riddles.org.uk, david@fetter.org, pgsql-hackers@lists.postgresql.org Subject: Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options From: Tatsuo Ishii In-Reply-To: References: <20250725.164914.458111718434162385.ishii@postgresql.org> <20250816.183329.1067490243501362986.ishii@postgresql.org> X-Mailer: Mew version 6.8 on Emacs 26.3 Mime-Version: 1.0 Content-Type: Text/Plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Host-Lookup-Failed: Reverse DNS lookup failed for 2409:11:4120:300:74d1:78e4:8d18:edb7 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk >> Attached are the v18 patches for adding RESPECT/IGNORE NULLS options >> to some window functions. Recent changes to doc/src/sgml/func.sgml >> required v17 to be rebased. Other than that, nothing has been changed. >> >> Oliver, do you have any comments on the patches? >> > > Looks good, tried it on the nth_value test script from a bit ago - I added > a 1 million rows test and it takes an average of 12 seconds on my i7. Thanks. I have moved the CF entry from PG19-1 to PG19-2 as PG19-1 has been already closed on July 31. Hope this help CF bot to catch the v18 patches. Best regards, -- Tatsuo Ishii SRA OSS K.K. English: http://www.sraoss.co.jp/index_en/ Japanese:http://www.sraoss.co.jp