Tag
DBOS explains how Postgres DELETE can scale for high-throughput workloads by tuning cache locality and index performance when enforcing data retention policies on tens of thousands of workflows per second, despite MVCC's inherent overhead.
PlanetScale achieved 118 million queries per second on their Neki platform with linear scalability across 512 shards, demonstrating exceptional performance and throughput in database operations.
This blog post details incremental optimizations to reduce ClickHouse query latency from over 85 seconds to sub-second, including changes to partition keys, join elimination, and aggressive merges.
This article explains why large DELETE operations in Postgres are inefficient and cause extra work, and recommends using DROP TABLE or TRUNCATE as more scalable alternatives for bulk data removal.
This article explains how Databricks' Lakebase architecture achieves a 5x improvement in Postgres write throughput by disabling Full Page Writes (FPW) and leveraging stateless compute with distributed storage.
The article analyzes the scalability limitations of using PostgreSQL as a job queue, specifically highlighting performance bottlenecks caused by MultiXact SLRU contention under high concurrency. It explains why this architecture fails in production despite working well in development and suggests considering alternatives.