Three years of Postgres partitioning mistakes—so you don't have to. Derk van Veen (Adyen) shares his Postgres partitioning cookbook.

Register for updates to POSETTE: An Event for Postgres 2026, Livestream 4 on Thu 18 Jun
https://posetteconf.com/2026/talks/my-postgres-partitioning-cookbook/

#PosetteConf #PostgreSQL #Postgres #Database #Community #OpenSource #Partitioning #DatabasePerformance #DBA

Postdoc Position in Data Warehousing @ TU Wien (Vienna)

Research on #dataWarehousing, #analytics & #databasePerformance bridging #dataSystems and #LLM interfaces.

Deadline: May 21, 2026

Application portal:
https://jobs.tuwien.ac.at/Job/266692

Lab:
https://dmki-tuwien.github.io

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

https://newsletter.tf/production-database-slowdown-limit-clause-issue/

Production database queries are now running much slower. This is because a small 'LIMIT' command in the code might be causing the database to do more work.

#DatabasePerformance, #SQLQueries, #TechTroubleshoot, #DeveloperTips, #ProductionIssues
https://newsletter.tf/production-database-slowdown-limit-clause-issue/

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