Premature optimization is the root of all evil in programming. We should forget about small efficiencies, say about 97% of the time. Yet we should not pass up our opportunities in that critical 3%. A good programmer will not be lulled into complacency by such reasoning, they will be wise to look carefully at the critical code; but only after that code is identified through profiling and measurement.

— Donald Knuth

←Tất cả Tags
✦
Tag

#optimization

1 bài viết về chủ đề này

❖

PostgreSQL EXPLAIN ANALYZE & Composite Index — Cặp bài trùm query chậm

25 tháng 7, 2026•Phong Hy

Học cách đọc EXPLAIN ANALYZE và thiết kế composite index trong PostgreSQL — tăng tốc query từ 12 giây xuống còn 45ms.

engineeringdatabasebackendoptimization
Đọc tiếp→
←Tất cả Tags•Blog→
✦
Home✦Blog✦Tags

Privacy Policy•Terms & Conditions© 2026 Phong Hy. Crafted with care.