» Tag
indexing
9 postsRandom Access Parquet: Fast Point Queries Over the Data Lake
Random Access Parquet uses an external index to enable low-latency point queries directly on data lake Parquet files, bypassing slow SQL engine overhead.
Diagnosing Slow Postgres Queries: Planning Time vs Execution Time
Learn to read EXPLAIN ANALYZE buffer stats to tell if a slow Postgres query needs partition/plan fixes or memory/storage fixes.
PostgreSQL Row-Level Security: Where the Performance Cost Hides
Benchmarks show PostgreSQL row-level security is free with proper indexing, but unstable helper functions and membership checks can add seconds of latency.
CommitBrief — AI code reviews, right in your terminal
A provider-agnostic, local-first CLI that reviews your staged changes, a historic range, or a whole GitHub pull request. Zero telemetry, no server. Free and open source.
commitbrief.comMicrosoft's tgrep: Trigram-Indexed grep in Rust, Up to 52x Faster
Microsoft's tgrep brings trigram-indexed, client/server grep to Rust, delivering up to 52x faster searches than ripgrep on large repos.
Vector Database Internals: From Brute-Force Search to IVF Indexing
A technical look at vector DB schema design, why brute-force search fails at scale, and how IVF indexing narrows search to relevant clusters.
ArborDb: a Rust document store with constant-time field reads
ArborDb is a Rust document store using zero-copy, offset-table blobs to give constant-time field reads regardless of record size.
Silent Data Corruption in Blockchain Indexing: 8 Notable Incidents
Eight incidents of silent data corruption in blockchain indexing raise concerns for engineers. Success signals can be misleading, affecting data integrity.
Rust File Watcher Consumed 23.6 GB of RAM, Ignoring Our Rules
A Rust file watcher ignored ignore rules, consuming 23.6 GB of RAM. Switching to NoCache resolved the issue.
85 hours spent updating 234 rows in the database
An unexpected query in the database spent 85 hours updating 234 rows. Important lessons on performance improvements were drawn.