Infrastructure●●Solid
BLOBs in MariaDB's Memory Engine – No More Disk Spills for Temp Tables
Let MEMORY engine handle BLOBs—avoids Aria disk spill overhead on JSON temp tables.
Big Brain
arcivanov
113mo ago
Back to browse
GitHub Repository
Sorted heap table AM for PostgreSQL with zone map scan pruning
57 starsPLpgSQL
Pg_sorted_heap–Physically sorted PostgreSQL with builtin vector search
by skuznetsov37·Mar 6, 2026·10 points·1 comment
AI Analysis
●●●BangerWizardryBig Brain
Zone-mapped sorted heap with 30x smaller IVF index than HNSW, no pgvector limits.
Strengths
- •Zone maps prune 519K blocks to 1, delivering 1-2 buffer reads for point queries at 100M rows.
- •IVF-PQ built-in beats pgvector's 2K-dim ceiling and 50GB HNSW footprint; 97-99% recall with reranking.
- •Compaction and merge logic designed for production: non-blocking variants, parameterized predicate support.
Weaknesses
- •Brand-new extension, unproven in large deployments, no production case studies yet.
- •Zone map v6 format adds maintenance complexity; limited to first two PK columns for efficacy.
Category
Target Audience
PostgreSQL DBAs, analytics engineers, vector search users at scale
Similar To
pgvector with HNSW · Elasticsearch vector search · DuckDB iceberg-style storage
Similar Projects
Developer Tools●●Solid
Pgsemantic – Point at your Postgres DB, get vector search instantly
Automates pgvector sync triggers so you skip boilerplate for existing tables.
Solve My ProblemSlick
varmabudharaju
1812mo ago
Education●●Solid
Hands-on x86-64 page table walk:finding a flag in physical RAM with GDB
Actually walk page tables in GDB instead of just reading diagrams.
WizardryNiche GemRabbit Hole
jazho76
401mo ago
Infrastructure●●Solid
HelixDB – A Graph Database built on Object-storage
Graph-vector-FTS in one database, but Weaviate and Neo4j already offer hybrid search.
Big BrainShip It
GeorgeCurtis
153422d ago
Developer Tools●●Solid
TableCraft – Stop burning AI tokens on table boilerplate
Schema-driven tables with server adapters, but TanStack Table + shadcn already cover 80% of this.
Solve My ProblemSlick
jacksonkasi
103mo ago
Infrastructure●●Solid
Pgproto – Native Protobuf Support for PostgreSQL
Native protobuf storage in Postgres with 65% savings over JSONB.
Niche GemBig Brain
paezand
102mo ago