#database-optimization
The latest AI and developer news about #database-optimization, with the original source and a short summary.
The latest AI and developer news about #database-optimization, with the original source and a short summary.
This article introduces practical strategies for operating production RAG workloads on Amazon Aurora PostgreSQL using pgvector 0.8.0, covering HNSW indexing, memory optimization, and observability.
Yeogi-eottae built an APM scatter chart by integrating OpenTelemetry and ClickHouse to visualize the distribution of individual requests.
Olive Young improved its coupon issuance system by introducing Redis to resolve DB contention issues that occur during high-traffic periods.
Before deploying VSMS, Market Kurly resolved a deadlock and optimized the DB to achieve the target TPS of 1500.
Test results showed CPU usage dropping from 100% to 60% and throughput increasing from 20,000 to 37,000.