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 1u0IW4-00G3Ku-41 for pgsql-hackers@arkaria.postgresql.org; Thu, 03 Apr 2025 11:13:48 +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 1u0IW2-005xWY-HA for pgsql-hackers@arkaria.postgresql.org; Thu, 03 Apr 2025 11:13:46 +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 ) id 1u0IW2-005xWP-4k for pgsql-hackers@lists.postgresql.org; Thu, 03 Apr 2025 11:13:46 +0000 Received: from meesny.iki.fi ([195.140.195.201]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u0IVy-002inV-1z for pgsql-hackers@lists.postgresql.org; Thu, 03 Apr 2025 11:13:45 +0000 Received: from [192.168.1.112] (iptv-hkibng21-58c090-167.dhcp.inet.fi [88.192.144.167]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) (Authenticated sender: hlinnaka) by meesny.iki.fi (Postfix) with ESMTPSA id 4ZSzcy45bZzyQX; Thu, 3 Apr 2025 14:13:38 +0300 (EEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=iki.fi; s=meesny; t=1743678819; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=ciHLHTs9JgQCSzMKIawGYG/DNuJ50mDMDSVRmS485zQ=; b=ETgWQqlyH0WyqVAXfO23icdM0dNuvUoNUfUqdyd16EuNiZYsBqnfMgbFgqsC+1AL51ZynT CRygxVQJfiSyVjptVwe+/83alMVURD0CQhvgeujZOHxq+q+aNuWStHCQGtOTAi+QbMnivf 9QMJumDxnJfEbj0dt1NZ80gdG1zP8bc= ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=iki.fi; s=meesny; t=1743678819; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=ciHLHTs9JgQCSzMKIawGYG/DNuJ50mDMDSVRmS485zQ=; b=mJn4J34nSPR/LTLIw6e/v6FLzTXPD1DVWo5XcNCXHc4h+oypTfmFLa3k/2ARvnsSSR5gps g45o4q+MwQqQplED5zhcD1+VY8ecQanU8zwkX7p8Ecz28XqsFavGDw8BbQAH52pF0Kr1rE FlpRVceyo7dtvGH5MR7Hmo2SqOtgY+w= ARC-Authentication-Results: i=1; ORIGINATING; auth=pass smtp.auth=hlinnaka smtp.mailfrom=hlinnaka@iki.fi ARC-Seal: i=1; s=meesny; d=iki.fi; t=1743678819; a=rsa-sha256; cv=none; b=d88Znr+OzeWHSiAy7V6TXegxx3qGEB6qXc6yMs4LbMwZKpapgmZvxIPa/S0w8aLACIPpgl uHWNW/sBK/Mz1NyIGjzfYmvbRPs8eXM/NJRHqmNFdy8er0+BsoeIa8tCmF9+C2fHiCd3sa rJFVkC2/EoNlXmhajBeS7RJIU2crjbw= Message-ID: <5699e74d-78d0-4eaf-badd-0c8e05595b19@iki.fi> Date: Thu, 3 Apr 2025 14:13:38 +0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: [PATCH] Add sortsupport for range types and btree_gist From: Heikki Linnakangas To: Bernd Helmle , Andrey Borodin Cc: Michael Paquier , jian he , PostgreSQL Hackers References: <7C9400DF-66FE-4308-BAD8-92FE3D0E55C6@yandex-team.ru> <0d9fbd59de15e2fc987a850c3d1f8a79a6ede825.camel@oopsware.de> <19c62e62c79b727d2c9a82eaeecfea5017001099.camel@oopsware.de> <4BADF8DD-A4D3-43AA-AA08-037F6FFA40BC@yandex-team.ru> <61128550659807032dd29c8c8a71674c818cbbb6.camel@oopsware.de> <7095B5FA-FADB-4524-B858-ECD14998710B@yandex-team.ru> <0176b173adfcff250543fe0aee2ef6137bd71953.camel@oopsware.de> <78499920f1e9ed5895423e735272ca2fdb90baf6.camel@oopsware.de> <770DB2DA-0B56-464A-87CE-5620CF12E114@yandex-team.ru> <6bd891c9e3aa12baea5c938267bdb5a1e50a299e.camel@oopsware.de> <64d324ce2a6d535d3f0f3baeeea7b25beff82ce4.camel@oopsware.de> <2d3078fa-4700-431f-99a5-91ae8ee3bf86@iki.fi> Content-Language: en-US In-Reply-To: <2d3078fa-4700-431f-99a5-91ae8ee3bf86@iki.fi> 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 02/04/2025 22:41, Heikki Linnakangas wrote: > On 02/04/2025 20:18, Heikki Linnakangas wrote: >> So I added it for the btree opfamily too, and moved the function to >> rangetypes.c since it's not just for gist anymore. I Ccmmitted that >> part, and will start looking more closely at the remaining btree_gist >> parts now. > > Here's an updated version of the remaining parts. Found a couple of bugs: Committed with some further cosmetic fixes. Thanks for the patience, this has been lingering for a long time, especially if you count the earlier attempt back in 2021! -- Heikki Linnakangas Neon (https://neon.tech)