Lmst

How we optimized Top K in Postgres

https://www.paradedb.com/blog/optimizing-top-k

#HackerNews #Postgres #Optimization #TopK #DatabasePerformance #DataEngineering

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.

https://www.the-main-thread.com/p/quarkus-postgresql-database-performance-mcp

#Java #Quarkus #PostgreSQL #DatabasePerformance #DevTools

#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/

Most 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

#PostgreSQL #DatabasePerformance #TOAST

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

📊 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

🚀 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

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

#PostgreSQL #PGDay #PPDD #Benchmarking #DatabasePerformance

#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

🚀 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! 😂
https://boringsql.com/posts/instant-database-clones/ #PostgreSQL18 #instantclones #Xeroxmachine #techupdates #databaseperformance #HackerNews #ngated

SQLite JSON at Full Index Speed Using Generated Columns

https://www.dbpro.app/blog/sqlite-json-virtual-columns-indexing

#HackerNews #SQLite #JSON #GeneratedColumns #Indexing #DatabasePerformance

Super fast aggregations in PostgreSQL 19

https://www.cybertec-postgresql.com/en/super-fast-aggregations-in-postgresql-19/

#HackerNews #SuperFastAggregations #PostgreSQL19 #DatabasePerformance #DataAnalysis #TechNews

In today's episode of "Tech Buzzword Bingo," folks are shocked to discover that #SQLite, the database equivalent of a Nokia 3310, can do 100,000 #transactions per second WITHOUT MVCC or a real server. 🤯 Apparently, using a MacBook Pro with a chip named after a fruit is the secret sauce! 🍏💻
https://andersmurphy.com/2025/12/02/100000-tps-over-a-billion-rows-the-unreasonable-effectiveness-of-sqlite.html #TechBuzzwordBingo #MacBookPro #DatabasePerformance #FruitChip #HackerNews #ngated

Benchmarking Postgres 17 vs. 18

https://planetscale.com/blog/benchmarking-postgres-17-vs-18

#HackerNews #Benchmarking #Postgres #Postgres17 #Postgres18 #DatabasePerformance #TechNews

Is Postgres read heavy or write heavy?

https://www.crunchydata.com/blog/is-postgres-read-heavy-or-write-heavy-and-why-should-you-care

#HackerNews #Postgres #Database #ReadWriteBalance #DatabasePerformance #SQLInsights

Performance tuning is about finding real issues, not adding complexity for the sake of it.

In his latest blog, Semab Tariq uses real EXPLAIN ANALYZE plans from production to show how to identify true bottlenecks, use indexes effectively, and recognize when further optimization adds no real value.

Read the full post: https://stormatics.tech/blogs/avoiding-over-optimization-via-explain-plans

#PostgreSQL #DatabasePerformance