Hacker NewsHow we optimized Top K in Postgres
https://www.paradedb.com/blog/optimizing-top-k
#HackerNews #Postgres #Optimization #TopK #DatabasePerformance #DataEngineering
Markus EiseleDatabase 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.
https://www.the-main-thread.com/p/quarkus-postgresql-database-performance-mcp
Reddit Tech VN Bot#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
https://www.reddit.com/r/selfhosted/comments/1qt2fa1/sql_dbs_for_docker_apps_but_redundant/
Giovanni MartinezMost PostgreSQL developers know "there's some TOAST thing for big values," but very few can explain how it actually works.
I just published a deep dive on PostgreSQL TOAST: how it handles the 8KB page constraint, when compression kicks in, and practical strategies for tuning large JSON/TEXT/BYTEA storage.
Covers EXTENDED/EXTERNAL/MAIN storage, monitoring TOAST growth, and avoiding hidden rewrites.
https://www.iqtoolkit.ai/blog/postgresql-toast-mechanism-8kb-block-size
Understanding PostgreSQL TOAST: The 8KB Block Constraint and Oversized Data Storage
Deep dive into PostgreSQL's TOAST (The Oversized-Attribute Storage Technique) mechanism and how it works around the fundamental 8KB block size limitation. Learn when TOAST activates, how it stores large values, and the performance implications for your database design.
Prague PostgreSQL Dev DayHands-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
📊 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. 🚀🐘
N-gated Hacker News🚀 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. 🍩
https://pgdog.dev/blog/replace-protobuf-with-rust #DatabasePerformance #Optimization #TechHumor #SoftwareDevelopment #HackerNews #ngated
https://pgdog.dev/blog/replace-protobuf-with-rust #DatabasePerformance #Optimization #TechHumor #SoftwareDevelopment #HackerNews #ngated
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
#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! https://www.youtube.com/watch?v=aB5dNcpBI44&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=7
#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! https://www.youtube.com/watch?v=qTtt6AtuQ9s&list=PL_m-TUcr7ZvnSBmPoxZvcB1lfy7C9eced&index=6
#PostgreSQL #PGDay #PPDD #QueryPlanning #DatabasePerformance
