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 1vFZtP-00E6VX-PR for pgsql-general@arkaria.postgresql.org; Sun, 02 Nov 2025 15:21:19 +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 1vFZtO-00Bksi-Is for pgsql-general@arkaria.postgresql.org; Sun, 02 Nov 2025 15:21:17 +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 1vFZtN-00BksR-AM; Sun, 02 Nov 2025 15:21:17 +0000 Received: from fhigh-a2-smtp.messagingengine.com ([103.168.172.153]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vFZtH-005aeM-17; Sun, 02 Nov 2025 15:21:15 +0000 Received: from phl-compute-10.internal (phl-compute-10.internal [10.202.2.50]) by mailfhigh.phl.internal (Postfix) with ESMTP id 8B21C140012E; Sun, 2 Nov 2025 10:21:06 -0500 (EST) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-10.internal (MEProxy); Sun, 02 Nov 2025 10:21:06 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm2; t=1762096866; x=1762183266; bh=9WzJe0/Mf/VYNiiUCCaFdBv20bByVPXsTWezISL9c7M=; b= itn1ULjPAq+/QpN1U0OFLRUb47Up+W3lBBz5InwadNvgkm3Ku3Jmr4cpL7Opg+Sg WIaheiD14DGHN3+PzGiOOOZLPdskwrVwV1ISt8HZgPIlVMucX50KhhFG1JyS61W0 O4jovwbSEoeOSDL1NrLPjmGWgcAeiZgHbEkl6IPUS52rwXabLZcBt9l/WdVIC1jZ GgcjV/bVbxOviemDHoNnqzll5OGF0IOiW4OcR1IXak5wg/qNd7BSKBYc2kNnVuw3 i5jnmmQshKbmaRH7pxzQiWKZXwAVDioWZbymqIiXODM5zfYPJ3AeKx6D50ziW5it RYVOpnbMctJXfq1AbXE0ww== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t=1762096866; x= 1762183266; bh=9WzJe0/Mf/VYNiiUCCaFdBv20bByVPXsTWezISL9c7M=; b=d EBeDvVT5LUgWngpQP1dbXzYjgzWumMIlf7gVqLYHf0EACmsMO5ZzQ1/n3uBEyBkS tPA3ihZ/Yx4Hav137QY7e389MBTRx4+PnbIagxkzULo8mN0Dlw06pZgg8wy8joeG peqMSKdXhepCVgkfGG4wEdzCBUKr1UCwTRK2+siEn/aV2zCM08Fpvmw1CnV33Tiu 5A9ynsQP/BLt1qsTDT1BhTUnCz5AMl6F1wsjsImBpseojYXYVPcUZuW62sRo5c5N ZeDHhurPGxhE5CoN+3ioewKmZq3Wq6zLhVsigawtniqODbPZ81XWoQBxUTs01tVu Hi4Sa44iq+h4ZRi+XtZsw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdeggddujeehiedtucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucenucfjughrpefkffggfgfuvfevfhfhjggtgfesthekre dttddvjeenucfhrhhomheptegurhhirghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhl rghvvghrsegrkhhlrghvvghrrdgtohhmqeenucggtffrrghtthgvrhhnpeehudffieduke evtdeitdefleffieejtefftdegteejieekuefgfedtffejtdejtdenucffohhmrghinhep phhoshhtghhrvghsqhhlrdhorhhgpdhpghignhdrohhrghdpghhithhhuhgsrdgtohhmne cuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprggurhhi rghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomhdpnhgspghrtghpthhtohepfedpmh houggvpehsmhhtphhouhhtpdhrtghpthhtohepshhivhgrphhrrghsrggurdhofhhfsehg mhgrihhlrdgtohhmpdhrtghpthhtohepphhgshhqlhdqrghnnhhouhhntggvsehpohhsth hgrhgvshhqlhdrohhrghdprhgtphhtthhopehpghhsqhhlqdhgvghnvghrrghlsehpohhs thhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sun, 2 Nov 2025 10:21:05 -0500 (EST) Message-ID: <511d8b14-5184-41ee-af55-18898ce5b53f@aklaver.com> Date: Sun, 2 Nov 2025 07:21:05 -0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: =?UTF-8?Q?Re=3A_=5BANNOUNCE=5D_BISCUIT_=E2=80=93_A_Bitmap-Based_Ind?= =?UTF-8?Q?exed_Search_Extension_for_PostgreSQL?= To: Sivaprasad , pgsql-announce@postgresql.org Cc: pgsql-general@postgresql.org References: Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 11/1/25 23:58, Sivaprasad wrote: > Hi all, FYI, this: https://www.postgresql.org/list/pgsql-announce/ "Announcement list pertaining to PostgreSQL and various third party software." is the announcement list. > > I'm excited to announce the release of BISCUIT, a new PostgreSQL > extension focused on > deterministic pattern matching using bitmaps and logical operations. > > Unlike pg_trgm, BISCUIT is deterministic — no verification required. > It uses bitmap-based indexing to accelerate complex LIKE and pattern > queries with > significant performance gains. > > Available on PGXN: https://pgxn.org/dist/biscuit/ > Source & Docs: https://github.com/crystallinecore/biscuit > > Key features: > - Bitmap-based indexed pattern matching > - Deterministic and exact results > - Works seamlessly with PostgreSQL indexing > - Lightweight, portable C extension > > Feedback and contributions are welcome! > > Best regards, > Sivaprasad Murali > Author, BISCUIT Extension > > -- Adrian Klaver adrian.klaver@aklaver.com