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.96) (envelope-from ) id 1vL1KZ-000l2R-2x for pgsql-hackers@arkaria.postgresql.org; Mon, 17 Nov 2025 15:39:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vL1JY-000i73-1d for pgsql-hackers@arkaria.postgresql.org; Mon, 17 Nov 2025 15:38: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.96) (envelope-from ) id 1vL1JY-000i6u-0g for pgsql-hackers@lists.postgresql.org; Mon, 17 Nov 2025 15:38:48 +0000 Received: from mail-wm1-x329.google.com ([2a00:1450:4864:20::329]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vL1JV-0000pS-2q for pgsql-hackers@lists.postgresql.org; Mon, 17 Nov 2025 15:38:47 +0000 Received: by mail-wm1-x329.google.com with SMTP id 5b1f17b1804b1-4779cc419b2so20335895e9.3 for ; Mon, 17 Nov 2025 07:38:46 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1763393925; x=1763998725; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=Vin3slBtJiIzwDYbJsMuQKyCBsggXdVOL5j6D+agK6o=; b=m6TYzIGXpERu1Dgbtqvgz9f6WEsYOgtOvjQe3llpbU5w18rkVQtElgYvDI88OXtUET WgfSwPX7s0B2jPKRqW3C6WF8Dr1uL3P1yEEFS4XFMg70dWXQSQd9p/bsfOKzT5hzwQTg E335V1eHFvFa6X85XCrx+n38wN49gCFqGxgKT65dvmb9cQS29Pr6BTz0nG9w6+k7jF/h srPHzC+KAaQNKxGP2lgwK7vCbQSaSs+Y9Hdnq7zzcVTqzTkfsL+KP5w/jqZ69H5McqX4 rx3AlRVp5GOGEVTEH/fXYhbauv4atzHU9xA+RUZgTK4WaL/NxpcL9eU7zy1pqXagx5BB 8NuA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1763393925; x=1763998725; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=Vin3slBtJiIzwDYbJsMuQKyCBsggXdVOL5j6D+agK6o=; b=AJquIryMlXNFAeLoh6dvuJy5uRbrX5urQlOMIl2MSv8goyrtZehrJN73TMb0+gdqfz YY2AAYh9cr4qdzbOp2N4kpvVFwnyfvfUCg1w1cKOckVp09W2LSKs/Ex5jk4pJOt0gfqY g5TN+Ji7YwwJ315Nz6SKZ33ZSgPW531A0UJXm6fA44NJcs2MWWJYGuPUMUj+34+oBxSF kSh3NDCUejRN7dYuQMY9N5332yxzLyoUOeCzr2mT205qh0uUPPoQRYMFGgZtF1KWpVt3 jPCtQ6k47gtfUy+iS9F8Wu7w508gvmngrAbVuENq7BY3auVDXZgmbqXPIPDiiXdITuzR hf/A== X-Gm-Message-State: AOJu0Yz6RBGbhXPKe3dQntEcUa+rf883STxBv2Rk4UvUG+p3SkkPYbpu T93437S6UHp9ftZRHlyp0DPYofLK+t94y02Mzvh9i/7z/wfhDBtnq2zx X-Gm-Gg: ASbGncuxU8dDWgohd/jBcoPs8LKbq5P67LQeGQvNEVbzGqXlBmpXfMcpo65mez3tAvt jFL3JGdntkndweT+GF9fuQHPP2EVp3zGakaHgeDAMJsH1lfmb/q5R5NIygrIpQQv6Y4xDEaA7HC eMVTUaFv8d5SXvv6gvetme8iNUoZkmUuppYXyQ7/FyP/TzUDgVbC5m6X+10xsw+uz0qzbUTjykR QxR9ZY9Jw+nIQIZanfsAhALA7fSCH9XgyOIFW+lOhMkIkcLkCuOffmGzRf4ep1Xv3cVr0Jc+3tn 6wE8dn89OqS0quBX/yqN+psUK8QKommOiot4dKY0zepnJ17cL89GDA5EfHf0Wo2enp0f8BKIr2i +5mAOe0xeZM09IUzgYBY9WjHtbn1IqJiN1/418mOC0/9UoaUiEhSH2hyjMgkGhfjL7uAgvzkcBA x/J3yEOg== X-Google-Smtp-Source: AGHT+IGTyA2p04JkDfH5ZCdhxJj/FErfAeYYrKf8WvYKX62YSSWINUOZWFp8PQ9+NTbTprcI9l4FjA== X-Received: by 2002:a05:600c:4452:b0:477:832c:86ae with SMTP id 5b1f17b1804b1-4778fe5c755mr108403565e9.12.1763393925048; Mon, 17 Nov 2025 07:38:45 -0800 (PST) Received: from [192.168.2.32] ([165.225.27.7]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-477a7cb24dfsm22843185e9.14.2025.11.17.07.38.44 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 17 Nov 2025 07:38:44 -0800 (PST) Message-ID: <78befa83-5cf2-4dd9-bf7b-9845df6b19ee@gmail.com> Date: Mon, 17 Nov 2025 16:38:43 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: tuple radix sort To: John Naylor Cc: PostgreSQL Hackers , Peter Geoghegan References: <97492f51-51cc-45cd-aeea-8ed6f48eccc2@gmail.com> Content-Language: en-US From: David Geier In-Reply-To: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi John! On 15.11.2025 03:47, John Naylor wrote: > On Sat, Nov 15, 2025 at 1:05 AM David Geier wrote: >> I understand that you want to make progress with the use case at hand >> but I feel like we're missing out on a lot of opportunity where the >> introduced code would also be very beneficial. > > The patch is independently beneficial, but is also just a stepping > stone toward something larger, and I don't yet know exactly how it's > going to look. Premature abstractions are just going to get in the > way. I'd be open to hear proposals for possible wider application > after the dust settles, but that's not going to happen during the PG19 > cycle. > That sounds like a good compromise. Let's see what else can profit from the new sorting code once we've got the tuple sort in. -- David Geier