SP-GiST BK-tree index extension for 64-bit perceptual hashes and Hamming-distance searches.
pgext.cloud · Source code · Documentation · Control file
| Package | bktree |
|---|---|
| Version | 1.0 |
| PostgreSQL versions | 15 |
| Repository | Unspecified |
| Extension type | Standard |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | Yes |
| Stars | 7 |
| Latest commit | 2023-01-13 |
| Catalogue updated | 2026-08-30 |
| pg_phash | Calculate Hamming distance between decimal-encoded perceptual image hashes |
| hamming_distance | Hamming distance and similarity functions for hexadecimal feature-vector strings. |
| bitstring_helpers | Helper C functions and aggregates for PostgreSQL bit varying data. |
| tlsh_gist | TLSH fuzzy-hash data type, distance operations, and GiST indexing for similarity search. |
| pg_emd | Fast approximate Earth Mover's Distance using dynamic tree embeddings |
| hyperspace | Four-dimensional point, box, and circle types with B-tree and SP-GiST/KD-tree operator classes. |
| colors | C functions for perceptual color-distance calculations in the CIE L*a*b* color space |
| pgvector | Custom vector type with Euclidean distance, cosine similarity, and prototype IVFFlat helpers. |