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 1wCq4f-002M5Z-26 for pgsql-hackers@arkaria.postgresql.org; Wed, 15 Apr 2026 02:33:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wCq4d-00EJDM-1k for pgsql-hackers@arkaria.postgresql.org; Wed, 15 Apr 2026 02:33:52 +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.96) (envelope-from ) id 1wCq4d-00EJDE-0p for pgsql-hackers@lists.postgresql.org; Wed, 15 Apr 2026 02:33:52 +0000 Received: from mail-wm1-x334.google.com ([2a00:1450:4864:20::334]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wCq4b-000000018dQ-45r2 for pgsql-hackers@lists.postgresql.org; Wed, 15 Apr 2026 02:33:51 +0000 Received: by mail-wm1-x334.google.com with SMTP id 5b1f17b1804b1-488971db0fdso61568385e9.0 for ; Tue, 14 Apr 2026 19:33:49 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1776220428; cv=none; d=google.com; s=arc-20240605; b=ISuIlyuHdjGysjRNdXutdTZcRzV/YaaXQmeEfi7ryzF8dX8c9ysbOea5hqQt9IqvrT 1BoT+C3qBkh5tpvQ7nMSvk9rfWVZYuj6VZ+vn3gT9p7NX7ePYq0BAK9aj/UuiMVGpYR6 rSFNrnSeis2lCEIzodoEYEFcWYMU3XVwOQ1gxEeeooOBnKCvum3eM2MyZSN6KU2qy6fs lIATDKCAiVIgvp3UIsH5e6rZ5c25sPbl6X3+OcWPDaGYQZ1VOiqBT8mFrm+vh632xDid bap0xYOfm3k2LFEDHeZEHyldHOdoVydIyKvsVVkwdHb0VAffm1UzLsIGIA+Nz1AzzSUR Lqeg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=yuOhPkAI2tHwm37PTwGLZwJjZeydNFnKL8N9ECcGId4=; fh=Es0KaBeGhOJTHI/krEXT9tmV0Spi+ET4/BSeuaUmjR8=; b=Yea6OF9UhE+NGMKA81wBFcMAUsRmdRCP8bDonli8mdb+eLW8yQ7MUq4baHhlDoGFTB cjo02kOW125qe9BllMY6XaD2onx1f9tTWquBN/xjMxTOHaNYns6bxDL5g1nU8tRQMrT8 FNRlc0HVdt630H0tyRwAke/lfDzj8IM+IJV5zliDjfnQuBK358iKvye840qjRl3+Yd1a GiIoEkypanpIhclXlxyhig/CQ5lMYPZDODwsKbcJU+D2BJiXsa5+eXeBD11xE/WLz79a 4xecOlXGirmmVAw1JoAmbfpjCn8+HulTbJFMF3QfrFYQaSfRyIHek263IVDqX7UeVMqA 783A==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1776220428; x=1776825228; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=yuOhPkAI2tHwm37PTwGLZwJjZeydNFnKL8N9ECcGId4=; b=CKdz6O46O0MJghYcicA27N2w8eaZWFPcUQg0RFt6Op5C7epyfjBuXHVis1QM+H7oMO EuuoYQEmIwh/LBAAC0c/fYXtS2Ih/0ulbwihTRJ1JqN5WD6k/9xSRCFbJ0Oe42Jl2y6m LTdqiewM/DE5mpcxQZ8MFIghEwuRwLC2Ouy7G2mS+VvTsWiB7rOVY2LVDWZ+CQgN89GV Jp8YrL/0erpSXuOTGLPa/kA3Yb0dsuhVBtGkAPihMR5ryxeCQ57nf/AKITVdLYQ5D2RJ NL3c5r3OuZDlnYdl1sALdfQFYxu11ep4Jiu18wzA9noJKA6wPOFnLw36wEid00tp96CQ g5Cg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776220428; x=1776825228; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=yuOhPkAI2tHwm37PTwGLZwJjZeydNFnKL8N9ECcGId4=; b=YltdjkGREcpA2W3s9PDd1dlfCbAjiL5KgfiSxB3C8D0gxl3IhCjH6matHlZqWGMGdz 6WanTfOMUvHmi5HWwWCGW0bwxvSNOC1Zxk1KC1ZQAo3jcZXaMhY3OU3bPVo1qa/l1TlT p4HP8fskfwH2a2jHXV9VBXL1aDP7khDgv30wV0YVELCts0udE92LKVgL6s+URbkfM2Sa xQIXlRS/9gA8zvpN3dyzUuDm0LyNh0oyH4DlBV4xWUFBej4dz/b3dMcJrfWUWWq+3NZi DEF0uQpSo3kgr0EVOsAcrVNggl0lnEQNAomVuA6LbeGwFiujsNeO8EcZaiwyPaqS8OWY /FXA== X-Forwarded-Encrypted: i=1; AFNElJ/cIvJ5zlC/7Z6vOOUgF7h4ZGsUqcKWbiKXPZN2B+MsUarmrdBdmuP4Kez+dJlNMv9wjuwagnEaSQHySG93@lists.postgresql.org X-Gm-Message-State: AOJu0YxUcp15jUCnuIvmPCR0NoBBRblaPVmRoEYiX/bv+2SJ2Hivylfo KYK+cRcIf5bcXSN9EZoxYMdOcUqgzNLXJij78Pvg8m7YPiSe+ktBJ7XX0axuAMgAB8p+qhLy6rN ErB/k0nV/OpbwbdThA7PfGoVvErP7JmU= X-Gm-Gg: AeBDieu3Ezy6rtEnGo3MKHUn4+EMjF+WxvWIClKQ+89w+/jpb9UA0Kfu6fsxqe43Dfg KEbIK5TisjEeEHPoG4UhoPIx53OnxRYroB/fFrx3WjhSJsa9281oA4uDhWXSxirpw59KyRr0Toc ACoFzqOS7mlcv1/zZ/G+IK/z53l5hhvyyQqNDKI+ZAeUZjebEYxsR2JDRtnwvQKcym7HPHBotHg W1/6LK3WlVDsJm25PZIICH/W4PNJQLwjzbAKLvclMTMntnWptURdcOGHP4yIka2XV7aoNL54OyI RiQno6UovENjeo8JWUXzuzwistDS7JFmjCz0pak2KeioRTcNvcfs8S3SFobUyoaWx7Wjuowx4vd uXOEjFZexZVm7Y1RgySY= X-Received: by 2002:a05:6000:186e:b0:43e:a70d:7622 with SMTP id ffacd0b85a97d-43ea70d791amr6580151f8f.22.1776220428397; Tue, 14 Apr 2026 19:33:48 -0700 (PDT) MIME-Version: 1.0 References: <278B9FE3-F349-4494-99C5-483105C1C999@gmail.com> <1900289.1776212948@sss.pgh.pa.us> <1913188.1776220247@sss.pgh.pa.us> In-Reply-To: <1913188.1776220247@sss.pgh.pa.us> From: David Rowley Date: Wed, 15 Apr 2026 14:33:36 +1200 X-Gm-Features: AQROBzDy_PzNE6-LJVCj2mbTTw9dkGXdLEQrOKDmD_kxi3Rb6DyQD_oMdJGCJ5E Message-ID: Subject: Re: Add bms_offset_members() function for bitshifting Bitmapsets To: Tom Lane Cc: Chao Li , PostgreSQL Developers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 15 Apr 2026 at 14:30, Tom Lane wrote: > > David Rowley writes: > > I'd not considered surprise-prone as an aspect. I understand we have > > bms_join and bms_union, which do the same thing if you only care about > > the value of the result and not what happens to the inputs. > > Sure, but bms_join is an optional optimization of the far safer > bms_union operation. It bothers me to create the optimized case > but not the base case. Hmm, yeah. That seems like a good argument for making a new set. I'll go make it so. David