#query-optimization

The latest AI and developer news about #query-optimization, with the original source and a short summary.

4B Parameter RL Model Reduces Postgres Query Planning Latency by 44.7%

A 4B parameter RL model has been released, reducing Postgres query planning latency by 44.7% and achieving up to 1.81x acceleration.

·2·2026.09.16 09:00

An Ideal Structure Doesn't Guarantee Fast Performance

SSG.COM discovered a duplicate query issue in its promotional event API and optimized performance through structural improvements.

·1·2026.06.30 09:00

Optimizing Trino Resources on YARN

By tuning YARN's RESERVED Resource and Trino settings, available memory was increased by about 40%.

·2·2024.11.26 16:00

[if kakao 2022] Optimal Aggregation Considering Batch Performance

To reduce the DB load that occurs when aggregating large volumes of data, a new Aggregation architecture is proposed instead of complex GroupBy queries.

·1·2022.12.09 20:00

Kakao Publishes Case Study on Optimizing Spark AQE with Coalescing Post Shuffle Partitions

With AQE enabled, the number of Shuffle partitions decreased from 10000 to 118, and Peak Memory dropped from 634.8GB to 332.0GB.

·2022.01.18 00:00