AI Briefing#database-performance
The latest AI and developer news about #database-performance, with the original source and a short summary.
The latest AI and developer news about #database-performance, with the original source and a short summary.
In Toss Securities Oracle DB, repeated commit waits of 0.1 seconds or more despite normal average CPU were caused by NIC interrupts concentrated on one socket, and most of it improved after distributing interrupts across two sockets.
PostgreSQL 18 significantly improves query performance and management efficiency through skip scan optimization and enhanced EXPLAIN features.
We identified and patched a query planner lock contention issue in a petabyte-scale ClickHouse cluster.
Dead tuples and the MVCC horizon slowly degrade Postgres queues.
Write throughput improved by up to 47%, support period extended to 5 years, and minor release support introduced for on-premises environments.
To reduce the DB load that occurs when aggregating large volumes of data, a new Aggregation architecture is proposed instead of complex GroupBy queries.
Inflearn analyzed the technical causes of the massive traffic surge and resulting service outage during a 100% discount event.
Due to page locking structures and unidirectional Linked Lists during Backward Scans, performance differences of up to 44% occur.
Test results showed CPU usage dropping from 100% to 60% and throughput increasing from 20,000 to 37,000.