Hacker News
- Operating on a minimal two-core Postgres instance: Query optimization insights https://robertrode.com/2023/11/15/operating-an-entire-company-on-a-minimal-two-core-postgresql-instance-query-optimization-insights-part-1.html 175 comments
- 10,000x Speedup for Postgres Queries: How to Make a Smart Optimizer More Stupid https://ottertune.com/blog/how-to-fix-slow-postgresql-queries/ 10 comments
- Optimizing Postgres queries at scale https://heap.io/blog/optimizing-postgres-queries-at-scale 17 comments
- Joe, a Postgres query optimization bot https://postgres.ai/blog/joe-0.5/ 37 comments
- Adaptive query optimization – ML to improve Postgres analytical queries https://github.com/tigvarts/aqo 2 comments
- PostgreSQL Query Optimization http://jinchengli.me/post/postgres-query-opt/ 12 comments
- Show HN: pg_plan_guarantee – Postgres Query Optimizer Hints, on Steroids. https://github.com/gurjeet/pg_plan_guarantee 5 comments
- How we optimized PostgreSQL queries 100x https://towardsdatascience.com/how-we-optimized-postgresql-queries-100x-ff52555eabe 5 comments postgresql
- How we optimized PostgreSQL queries 100x https://towardsdatascience.com/how-we-optimized-postgresql-queries-100x-ff52555eabe 39 comments programming
- Simple Tips for PostgreSQL Query Optimization https://cube.dev/blog/postgresql-query-optimization/ 10 comments programming
- Optimizing postgresql query for DISTINCT values: this improved my query time from seconds to 1ms http://zogovic.com/post/44856908222/optimizing-postgresql-query-for-distinct-values 6 comments programming
- What’s new in the Postgres 16 query planner / optimizer https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/what-s-new-in-the-postgres-16-query-planner-optimizer/ba-p/4051828 10 comments postgresql
- Operating an Entire Company on a Minimal Two-Core PostgreSQL Instance: Query Optimization Insights, Part 1 https://robertrode.com/2023/11/15/operating-an-entire-company-on-a-minimal-two-core-postgresql-instance-query-optimization-insights-part-1.html 5 comments postgresql
- 10 Tips to Optimize PostgreSQL Queries in Your Django Project https://blog.gitguardian.com/10-tips-to-optimize-postgresql-queries-in-your-django-project/ 4 comments django
- What’s new in the Postgres 16 query planner / optimizer (cross post from r/postgresql) https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/what-s-new-in-the-postgres-16-query-planner-optimizer/ba-p/4051828 13 comments programming
- What's new in the Postgres 16 query planner / optimizer (cross post from r/postgresql) https://www.citusdata.com/blog/2024/02/08/whats-new-in-postgres-16-query-planner-optimizer/ 9 comments sql