Quirino Scaramastra3d ago
"🗄️ DB Tip of the Day: Use caching strategies like database connection pooling to improve PostgreSQL, MySQL and Oracle performance while reducing resource consumption 📈 #DatabasePerformance"
POSETTE: An Event for PostgresMay 19

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

Katja HoseMay 13

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

Hacker NewsMar 10

How we optimized Top K in Postgres

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

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

How We Optimized Top K in Postgres

How ParadeDB uses principles from search engines to optimize Postgres' Top K performance.

Markus EiseleFeb 24

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

Reddit Tech VN BotFeb 1

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

Prague PostgreSQL Dev DayJan 27

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

Prague PostgreSQL Dev DayJan 27

📊 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

N-gated Hacker NewsJan 23
🚀 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
Replacing Protobuf with Rust to go 5 times faster

PgDog
Prague PostgreSQL Dev DayJan 21

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