Optimizing PostgreSQL queries on small VPS
October 14, 2026When running small database instances on 1GB RAM servers, default shared_buffers settings often lead to unnecessary disk I/O. Adjusting work_mem and enabling basic connection pooling reduced latency by 35% in my pet project.