home.social

#databaseperformance — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #databaseperformance, aggregated by home.social.

  1. Production Query Lags, Developer Points to "Small Limit"

    Production database queries are running slow. A developer says a small 'LIMIT' clause might be the problem. Find out why this happens and how to fix it.

    #DatabasePerformance, #SQLQueries, #TechTroubleshoot, #DeveloperTips, #ProductionIssues

    newsletter.tf/production-datab

  2. Production Query Lags, Developer Points to "Small Limit"

    Production database queries are running slow. A developer says a small 'LIMIT' clause might be the problem. Find out why this happens and how to fix it.

    #DatabasePerformance, #SQLQueries, #TechTroubleshoot, #DeveloperTips, #ProductionIssues

    newsletter.tf/production-datab

  3. Database performance problems are rarely about one slow query.
    They are about patterns you don’t see until production.

    In this article, I show how to inspect real PostgreSQL behavior from a Quarkus app using pg_stat_statements, hypopg, and a PostgreSQL MCP server connected through IBM Bob.

    No dashboards. No guesswork. Real data, real feedback loops.

    the-main-thread.com/p/quarkus-

    #Java #Quarkus #PostgreSQL #DatabasePerformance #DevTools

  4. Database performance problems are rarely about one slow query.
    They are about patterns you don’t see until production.

    In this article, I show how to inspect real PostgreSQL behavior from a Quarkus app using pg_stat_statements, hypopg, and a PostgreSQL MCP server connected through IBM Bob.

    No dashboards. No guesswork. Real data, real feedback loops.

    the-main-thread.com/p/quarkus-

    #Java #Quarkus #PostgreSQL #DatabasePerformance #DevTools

  5. Database performance problems are rarely about one slow query.
    They are about patterns you don’t see until production.

    In this article, I show how to inspect real PostgreSQL behavior from a Quarkus app using pg_stat_statements, hypopg, and a PostgreSQL MCP server connected through IBM Bob.

    No dashboards. No guesswork. Real data, real feedback loops.

    the-main-thread.com/p/quarkus-

    #Java #Quarkus #PostgreSQL #DatabasePerformance #DevTools

  6. Database performance problems are rarely about one slow query.
    They are about patterns you don’t see until production.

    In this article, I show how to inspect real PostgreSQL behavior from a Quarkus app using pg_stat_statements, hypopg, and a PostgreSQL MCP server connected through IBM Bob.

    No dashboards. No guesswork. Real data, real feedback loops.

    the-main-thread.com/p/quarkus-

    #Java #Quarkus #PostgreSQL #DatabasePerformance #DevTools

  7. Database performance problems are rarely about one slow query.
    They are about patterns you don’t see until production.

    In this article, I show how to inspect real PostgreSQL behavior from a Quarkus app using pg_stat_statements, hypopg, and a PostgreSQL MCP server connected through IBM Bob.

    No dashboards. No guesswork. Real data, real feedback loops.

    the-main-thread.com/p/quarkus-

    #Java #Quarkus #PostgreSQL #DatabasePerformance #DevTools

  8. #Docker #SQL #NAS #KỹThuật #TựChủ #HệThốngTựXửLý
    Khi dùng NAS (RAID5) cho DB SQL trong Docker/Portainer Swarm, dữ liệu dễ bị lỗi & trễ phản hồi. Lệnh mới: bỏ Swarm, tìm giải pháp lưu trữ SQL an toàn, đảm bảo sao lưu và phục hồi nhanh. Cần mẹo từ DevOps?

    #Docker #SQL #NAS #NetworkEngineering #SelfHosted #Kubernetes #RAID5 #DatabasePerformance

    reddit.com/r/selfhosted/commen

  9. Hands-on with PgBouncer at P2D2! 🐘 Josef Machytka led a workshop exploring connection pooling, prepared statements, HA patterns, single-threaded vs multithreaded designs, and practical production use cases. Learn how to scale and optimize your Postgres connections!

    #PostgreSQL #P2D2 #PgBouncer #ConnectionPooling #DatabasePerformance #DBA #PostgresExperts

  10. Hands-on with PgBouncer at P2D2! 🐘 Josef Machytka led a workshop exploring connection pooling, prepared statements, HA patterns, single-threaded vs multithreaded designs, and practical production use cases. Learn how to scale and optimize your Postgres connections!

    #PostgreSQL #P2D2 #PgBouncer #ConnectionPooling #DatabasePerformance #DBA #PostgresExperts

  11. Hands-on with PgBouncer at P2D2! 🐘 Josef Machytka led a workshop exploring connection pooling, prepared statements, HA patterns, single-threaded vs multithreaded designs, and practical production use cases. Learn how to scale and optimize your Postgres connections!

    #PostgreSQL #P2D2 #PgBouncer #ConnectionPooling #DatabasePerformance #DBA #PostgresExperts

  12. Hands-on with PgBouncer at P2D2! 🐘 Josef Machytka led a workshop exploring connection pooling, prepared statements, HA patterns, single-threaded vs multithreaded designs, and practical production use cases. Learn how to scale and optimize your Postgres connections!

    #PostgreSQL #P2D2 #PgBouncer #ConnectionPooling #DatabasePerformance #DBA #PostgresExperts

  13. Hands-on with PgBouncer at P2D2! 🐘 Josef Machytka led a workshop exploring connection pooling, prepared statements, HA patterns, single-threaded vs multithreaded designs, and practical production use cases. Learn how to scale and optimize your Postgres connections!

    #PostgreSQL #P2D2 #PgBouncer #ConnectionPooling #DatabasePerformance #DBA #PostgresExperts

  14. 📊 PostgreSQL Query Optimization in action at #P2D2! Henrietta Dombrovskaya leads a workshop on writing efficient queries—reading execution plans, choosing the right indexes, and more. All wrapped up with the Ultimate Optimization Algorithm. 🚀🐘

    #PostgreSQL #QueryOptimization #DatabasePerformance

  15. 📊 PostgreSQL Query Optimization in action at #P2D2! Henrietta Dombrovskaya leads a workshop on writing efficient queries—reading execution plans, choosing the right indexes, and more. All wrapped up with the Ultimate Optimization Algorithm. 🚀🐘

    #PostgreSQL #QueryOptimization #DatabasePerformance

  16. 📊 PostgreSQL Query Optimization in action at #P2D2! Henrietta Dombrovskaya leads a workshop on writing efficient queries—reading execution plans, choosing the right indexes, and more. All wrapped up with the Ultimate Optimization Algorithm. 🚀🐘

    #PostgreSQL #QueryOptimization #DatabasePerformance

  17. 📊 PostgreSQL Query Optimization in action at #P2D2! Henrietta Dombrovskaya leads a workshop on writing efficient queries—reading execution plans, choosing the right indexes, and more. All wrapped up with the Ultimate Optimization Algorithm. 🚀🐘

    #PostgreSQL #QueryOptimization #DatabasePerformance

  18. 📊 PostgreSQL Query Optimization in action at #P2D2! Henrietta Dombrovskaya leads a workshop on writing efficient queries—reading execution plans, choosing the right indexes, and more. All wrapped up with the Ultimate Optimization Algorithm. 🚀🐘

    #PostgreSQL #QueryOptimization #DatabasePerformance

  19. 🚀 Imagine thinking you can harness the raw power of #Rust to make your database proxy five times faster, only to realize #Protobuf was the bottleneck all along! 🤦‍♂️ It's like blaming the tires for your car's poor gas mileage while you're revving the engine at a screaming 9000 RPM. 🍩
    pgdog.dev/blog/replace-protobu #DatabasePerformance #Optimization #TechHumor #SoftwareDevelopment #HackerNews #ngated

  20. 🚀 Imagine thinking you can harness the raw power of #Rust to make your database proxy five times faster, only to realize #Protobuf was the bottleneck all along! 🤦‍♂️ It's like blaming the tires for your car's poor gas mileage while you're revving the engine at a screaming 9000 RPM. 🍩
    pgdog.dev/blog/replace-protobu #DatabasePerformance #Optimization #TechHumor #SoftwareDevelopment #HackerNews #ngated

  21. 🚀 Imagine thinking you can harness the raw power of #Rust to make your database proxy five times faster, only to realize #Protobuf was the bottleneck all along! 🤦‍♂️ It's like blaming the tires for your car's poor gas mileage while you're revving the engine at a screaming 9000 RPM. 🍩
    pgdog.dev/blog/replace-protobu #DatabasePerformance #Optimization #TechHumor #SoftwareDevelopment #HackerNews #ngated

  22. 🚀 Imagine thinking you can harness the raw power of #Rust to make your database proxy five times faster, only to realize #Protobuf was the bottleneck all along! 🤦‍♂️ It's like blaming the tires for your car's poor gas mileage while you're revving the engine at a screaming 9000 RPM. 🍩
    pgdog.dev/blog/replace-protobu #DatabasePerformance #Optimization #TechHumor #SoftwareDevelopment #HackerNews #ngated

  23. Day 1 spotlight! 🌟

    🕘 9:00 – Hettie Dombrovskaya: Master query optimization, read execution plans, choose the right indexes, and make your queries lightning-fast.

    🕜 13:30 – Josef Machytka: Dive into PgBouncer, explore single-threaded vs. multithreaded designs, and learn practical scaling tips. ▶️ Don’t miss these!

    #PostgreSQL #PGDay #PPDD #QueryOptimization #PgBouncer #DatabasePerformance

  24. Day 1 spotlight! 🌟

    🕘 9:00 – Hettie Dombrovskaya: Master query optimization, read execution plans, choose the right indexes, and make your queries lightning-fast.

    🕜 13:30 – Josef Machytka: Dive into PgBouncer, explore single-threaded vs. multithreaded designs, and learn practical scaling tips. ▶️ Don’t miss these!

    #PostgreSQL #PGDay #PPDD #QueryOptimization #PgBouncer #DatabasePerformance

  25. Day 1 spotlight! 🌟

    🕘 9:00 – Hettie Dombrovskaya: Master query optimization, read execution plans, choose the right indexes, and make your queries lightning-fast.

    🕜 13:30 – Josef Machytka: Dive into PgBouncer, explore single-threaded vs. multithreaded designs, and learn practical scaling tips. ▶️ Don’t miss these!

    #PostgreSQL #PGDay #PPDD #QueryOptimization #PgBouncer #DatabasePerformance

  26. Day 1 spotlight! 🌟

    🕘 9:00 – Hettie Dombrovskaya: Master query optimization, read execution plans, choose the right indexes, and make your queries lightning-fast.

    🕜 13:30 – Josef Machytka: Dive into PgBouncer, explore single-threaded vs. multithreaded designs, and learn practical scaling tips. ▶️ Don’t miss these!

    #PostgreSQL #PGDay #PPDD #QueryOptimization #PgBouncer #DatabasePerformance

  27. Day 1 spotlight! 🌟

    🕘 9:00 – Hettie Dombrovskaya: Master query optimization, read execution plans, choose the right indexes, and make your queries lightning-fast.

    🕜 13:30 – Josef Machytka: Dive into PgBouncer, explore single-threaded vs. multithreaded designs, and learn practical scaling tips. ▶️ Don’t miss these!

    #PostgreSQL #PGDay #PPDD #QueryOptimization #PgBouncer #DatabasePerformance

  28. #throwback What started as a simple DBaaS comparison turned into a deep dive into PostgreSQL benchmarking
    🚀 Dirk Krautschick shares hard-earned lessons on tools, workloads, tuning, and real vs synthetic benchmarks. Avoid common pitfalls and benchmark smarter.

    ▶️ Watch now! youtube.com/watch?v=aB5dNcpBI4

    #PostgreSQL #PGDay #PPDD #Benchmarking #DatabasePerformance

  29. #throwback What started as a simple DBaaS comparison turned into a deep dive into PostgreSQL benchmarking
    🚀 Dirk Krautschick shares hard-earned lessons on tools, workloads, tuning, and real vs synthetic benchmarks. Avoid common pitfalls and benchmark smarter.

    ▶️ Watch now! youtube.com/watch?v=aB5dNcpBI4

    #PostgreSQL #PGDay #PPDD #Benchmarking #DatabasePerformance

  30. #throwback What started as a simple DBaaS comparison turned into a deep dive into PostgreSQL benchmarking
    🚀 Dirk Krautschick shares hard-earned lessons on tools, workloads, tuning, and real vs synthetic benchmarks. Avoid common pitfalls and benchmark smarter.

    ▶️ Watch now! youtube.com/watch?v=aB5dNcpBI4

    #PostgreSQL #PGDay #PPDD #Benchmarking #DatabasePerformance

  31. #throwback What started as a simple DBaaS comparison turned into a deep dive into PostgreSQL benchmarking
    🚀 Dirk Krautschick shares hard-earned lessons on tools, workloads, tuning, and real vs synthetic benchmarks. Avoid common pitfalls and benchmark smarter.

    ▶️ Watch now! youtube.com/watch?v=aB5dNcpBI4

    #PostgreSQL #PGDay #PPDD #Benchmarking #DatabasePerformance

  32. #throwback What started as a simple DBaaS comparison turned into a deep dive into PostgreSQL benchmarking
    🚀 Dirk Krautschick shares hard-earned lessons on tools, workloads, tuning, and real vs synthetic benchmarks. Avoid common pitfalls and benchmark smarter.

    ▶️ Watch now! youtube.com/watch?v=aB5dNcpBI4

    #PostgreSQL #PGDay #PPDD #Benchmarking #DatabasePerformance

  33. #throwback How does PostgreSQL estimate rows without counting them? 📊 Sadeq Dousti delivers a 100% live demo on statistics, query planning, autovacuum tuning, and multi-column stats for better performance. Learn what really drives your plans.

    ▶️ Watch now! youtube.com/watch?v=qTtt6AtuQ9

    #PostgreSQL #PGDay #PPDD #QueryPlanning #DatabasePerformance

  34. #throwback How does PostgreSQL estimate rows without counting them? 📊 Sadeq Dousti delivers a 100% live demo on statistics, query planning, autovacuum tuning, and multi-column stats for better performance. Learn what really drives your plans.

    ▶️ Watch now! youtube.com/watch?v=qTtt6AtuQ9

    #PostgreSQL #PGDay #PPDD #QueryPlanning #DatabasePerformance

  35. #throwback How does PostgreSQL estimate rows without counting them? 📊 Sadeq Dousti delivers a 100% live demo on statistics, query planning, autovacuum tuning, and multi-column stats for better performance. Learn what really drives your plans.

    ▶️ Watch now! youtube.com/watch?v=qTtt6AtuQ9

    #PostgreSQL #PGDay #PPDD #QueryPlanning #DatabasePerformance

  36. #throwback How does PostgreSQL estimate rows without counting them? 📊 Sadeq Dousti delivers a 100% live demo on statistics, query planning, autovacuum tuning, and multi-column stats for better performance. Learn what really drives your plans.

    ▶️ Watch now! youtube.com/watch?v=qTtt6AtuQ9

    #PostgreSQL #PGDay #PPDD #QueryPlanning #DatabasePerformance

  37. #throwback How does PostgreSQL estimate rows without counting them? 📊 Sadeq Dousti delivers a 100% live demo on statistics, query planning, autovacuum tuning, and multi-column stats for better performance. Learn what really drives your plans.

    ▶️ Watch now! youtube.com/watch?v=qTtt6AtuQ9

    #PostgreSQL #PGDay #PPDD #QueryPlanning #DatabasePerformance

  38. 🚀 Oh joy, PostgreSQL 18 now has "instant" clones, because who doesn't love watching their #database pretend to be a Xerox machine? 🤦‍♂️ Just remember, it's as thrilling as watching paint dry—but now with benchmarks and #XFS proofs! 😂
    boringsql.com/posts/instant-da #PostgreSQL18 #instantclones #Xeroxmachine #techupdates #databaseperformance #HackerNews #ngated