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 1vFS3H-00C1GF-Mf for pgsql-general@arkaria.postgresql.org; Sun, 02 Nov 2025 06:58:58 +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 1vFS3F-009cRY-Gb for pgsql-general@arkaria.postgresql.org; Sun, 02 Nov 2025 06:58:56 +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 1vFS3F-009cRP-59 for pgsql-general@lists.postgresql.org; Sun, 02 Nov 2025 06:58:56 +0000 Received: from mail-qk1-x741.google.com ([2607:f8b0:4864:20::741]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vFS3C-0050aX-0d for pgsql-general@postgresql.org; Sun, 02 Nov 2025 06:58:54 +0000 Received: by mail-qk1-x741.google.com with SMTP id af79cd13be357-88f8f346c2cso349167885a.0 for ; Sat, 01 Nov 2025 23:58:54 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1762066733; x=1762671533; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=mjGvZDRexjb+SXy55DiX99afZbsh7WRlIgsf1LcFq48=; b=XnjSNz4F7vayST9DE3LP8g9hx/DknpM+OUrcEXf/JFsGNkQWC0zWYK0p2t0gcypYsB YgSQfJt41DCSjwU5cSZ8UM/F5ugCFoXrr23defv51wmzpm0l/IaFI5qMLcbkvdauYh3P 0JQfrOp6h5RVkp1zhYmMb/+Xpd/bmOolgSljEkMsOBeL5NR8PhFEegjHwWPOkeztriFB EseQmkmRnAJYklTIVeqsfu1aHH0cxXMPTQ7Oc3JAt9cjrZMGHvEJfc8gLwADzGcaRQMu VXG+BLdBeDBMIksohQhAesuuclymImTSYfCk03nIuaagLLB6YEPCK3sbQ35ukiJTAVvn 317Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1762066733; x=1762671533; h=content-transfer-encoding:cc:to:subject:message-id:date:from :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=mjGvZDRexjb+SXy55DiX99afZbsh7WRlIgsf1LcFq48=; b=tOy69hL+9Ug1S31I6Hb4hqLNAnmdwoYbakh+EgGo/HBy8y3OIlouAO31mf7tENGbNh Bl38vkeUCBPNpFkAr4z9WfJlCvil0MJFwf6gL4/1eid3lD8eShuHbWJrNnpj0Gl1RlpF kxKFqjj2USunhuqgA52IXwVpyu6RvCthhOfYvO15O/xJsWRK5KZYGES06oO5jAwWeQhr 1sGrCLfMPCfOOiplx9hJEBbMt5WuTCIc1iHuTiUKRY7eBIg+AS+pMCSrR+nO8xqji9PH cWAGD0+Dg6WxwINK616OsmMIvDqWCtwDdu7xUhMeCOPvmq5UmTnB4xepOoFQ01f2dmHM fzig== X-Gm-Message-State: AOJu0YxWG62j08543RYwihesCu0wjGp85v8BbCMyWONE1JFz4zTOc62i v2e0LpEXchlhIsyAtaYW60Qc2spOTgVAgeOtFhQW2zj28dDUya66qyw//FVE0rFb2QpdnkL6Khn S1Fi5LEjwE7TpjmuWaiSBVYBY/exYY4ZBj9sA9iI= X-Gm-Gg: ASbGncsGsUra90RMfxzXINH+X9SQ34j5BvJ6grcT/oHTDNMXj7eENPa18NTlzQWFDyQ VDvjP2DqlumqscNGF7B63oF9KPUjxNrcltBgQoO++65CUtKWqot9/u3Bew/lXmPKfVryDkVua1X Zb5OBsdAr6hfqc/hQY8YjPXaS3Rap2RA4RkpdPr0kRfuga85iqO7mqFcpkbCY+7/eX9yYaZLKAL QasxjY45QChc0K5+DO8QeAByV26V4ALOxcVux+K5Sc7g6LpsVBrupnP9TcKdMasKpqseDnRZw== X-Google-Smtp-Source: AGHT+IHmbMYSVQ7PVKx/rT8LOzE3kN5rD11E/Ij591JV5/JVdYBOQ6TNdk9p0iJLT7pJEcIgyONAtvx4XdiOp44U1B8= X-Received: by 2002:a05:620a:4709:b0:8ab:699b:c056 with SMTP id af79cd13be357-8ab9a629c9fmr1147588385a.53.1762066733058; Sat, 01 Nov 2025 23:58:53 -0700 (PDT) MIME-Version: 1.0 From: Sivaprasad Date: Sun, 2 Nov 2025 12:28:41 +0530 X-Gm-Features: AWmQ_bnU2eY2eELuu57_DZVoM5NW80mqS4ZkXWcT-Z58Dbv4TEVnAn1PzKsUI28 Message-ID: Subject: =?UTF-8?Q?=5BANNOUNCE=5D_BISCUIT_=E2=80=93_A_Bitmap=2DBased_Indexed_Search?= =?UTF-8?Q?_Extension_for_PostgreSQL?= To: pgsql-announce@postgresql.org Cc: pgsql-general@postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi all, 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 =E2=80=94 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