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 1trAKo-00FfE1-H9
	for pgsql-hackers@arkaria.postgresql.org; Sun, 09 Mar 2025 06:40:26 +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 1trAKk-000z60-Hm
	for pgsql-hackers@arkaria.postgresql.org; Sun, 09 Mar 2025 06:40:22 +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 <ishii@postgresql.org>)
	id 1trAKk-000z4u-7K
	for pgsql-hackers@lists.postgresql.org; Sun, 09 Mar 2025 06:40:22 +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 <ishii@postgresql.org>)
	id 1trAKf-001oLB-2n
	for pgsql-hackers@postgresql.org;
	Sun, 09 Mar 2025 06:40:21 +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=HFx+WnpsM+NFyarbelc8bYZGFk7bjc9UL3Wn91J7ExQ=; b=JKmtTSPmzalWJhxjJBYG2aH3Jd
	PAG9oW4HPnO+G8GPMl6qSQd4+LYhUD8BAoxtSjIhQw/AFfnH5mEwiQVZ2pcUOgfy8XCmcFoxz0k7E
	eOW6gzM3U8DLcjK9lCiGxp7WWzttNIfabeqFAPo349AZOt9g3ZLMUwI+Ks/dGN95+hRTRyGcdJ0CB
	vztba/4pd5LDxLjq54acyjmf/VX6GM+h1DiaFdGUwBJvjm/XBy/qwFG/lM2gKpszksvH+OC9xn/Cq
	Af1C+aMHF9KHaclOxv9CCKPmtaFfvPjSx5HiBtWPh0ey3QZqs/9AowvGNaXfvI0z8YsRWc3VzmDue
	KFdfapmg==;
Received: from [2409:11:4120:300:e407:3825:316:f78e] (helo=localhost)
	by meldrar.postgresql.org with esmtpsa  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_CHACHA20_POLY1305_SHA256
	(Exim 4.96)
	(envelope-from <ishii@postgresql.org>)
	id 1trAKb-006NOy-1V;
	Sun, 09 Mar 2025 06:40:15 +0000
Date: Sun, 09 Mar 2025 15:39:57 +0900 (JST)
Message-Id: <20250309.153957.1921541382600841592.ishii@postgresql.org>
To: ojford@gmail.com
Cc: krasiyan@gmail.com, tgl@sss.pgh.pa.us, vik@postgresfriends.org,
 pgsql-hackers@postgresql.org, andrew@tao11.riddles.org.uk, david@fetter.org
Subject: Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options
From: Tatsuo Ishii <ishii@postgresql.org>
In-Reply-To: 
 <CAGMVOdvCwq-jUYgBA1H_3oeHR7HOYTSGtwPoFsJPkyRfjWRVTQ@mail.gmail.com>
References: 
 <CAGMVOdvtAEvv3KgkFoa2W5-vpz--QEvrVbvS84ZikcCb-SyA6g@mail.gmail.com>
	<20250228.204851.1356677729897999622.ishii@postgresql.org>
	<CAGMVOdvCwq-jUYgBA1H_3oeHR7HOYTSGtwPoFsJPkyRfjWRVTQ@mail.gmail.com>
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:e407:3825:316:f78e (failed)
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/20250309.153957.1921541382600841592.ishii%40postgresql.org>
Precedence: bulk

> Attached version removes the non-nulls array. That seems to speed
> everything up.  Running the above query with 1 million rows averages 450ms,
> similar when using lead/lag.

Great. However, CFbot complains about the patch:

https://cirrus-ci.com/task/6364194477441024

Best reagards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp