#databaseperformance — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #databaseperformance, aggregated by home.social.
-
New security, maintenance and analytics features for Azure Database for PostgreSQL
#PostgreSQL #AzurePostgreSQL #MicrosoftAzure #DatabaseSecurity #DatabasePerformance #CloudDatabase #DataAnalytics
https://techcommunity.microsoft.com/blog/adforpostgresql/announcing-new-security-maintenance-and-analytics-features-for-postgresql-at-mic/4524559?wt.mc_id=DP-MVP-4015656 -
New security, maintenance and analytics features for Azure Database for PostgreSQL
#PostgreSQL #AzurePostgreSQL #MicrosoftAzure #DatabaseSecurity #DatabasePerformance #CloudDatabase #DataAnalytics
https://techcommunity.microsoft.com/blog/adforpostgresql/announcing-new-security-maintenance-and-analytics-features-for-postgresql-at-mic/4524559?wt.mc_id=DP-MVP-4015656 -
Last day to register to Brent Ozar's 2026 Live Online Classes with a 50% discount.
And you can stack an extra 10% off on top of that.
Find out how to claim the exra discount: https://vladdba.com/2026/06/23/extra-10-off-brent-ozars-live-classes/
#SQLServer #DBA #BrentOzar #DatabasePerformance #TechTraining #sql #performance #mssql #sqldba -
PostgreSQL Benchmark: AWS RDS vs. Self-Hosted on Hetzner (2026)
https://hostim.dev/blog/postgres-benchmark-rds-vs-hostim-vs-self-hosted/
Comments: https://news.ycombinator.com/item?id=48816129
#HackerNews #PostgreSQL #Benchmark #AWS #RDS #SelfHosted #Hetzner #DatabasePerformance
-
PostgreSQL Benchmark: AWS RDS vs. Self-Hosted on Hetzner (2026)
https://hostim.dev/blog/postgres-benchmark-rds-vs-hostim-vs-self-hosted/
Comments: https://news.ycombinator.com/item?id=48816129
#HackerNews #PostgreSQL #Benchmark #AWS #RDS #SelfHosted #Hetzner #DatabasePerformance
-
PostgreSQL and the OOM Killer: Why You Must Use Strict Memory Overcommit
https://www.ubicloud.com/blog/postgresql-and-the-oom-killer-why-we-use-strict-memory-overcommit
#HackerNews #PostgreSQL #OOMKiller #MemoryManagement #StrictOvercommit #DatabasePerformance
-
PostgreSQL and the OOM Killer: Why You Must Use Strict Memory Overcommit
https://www.ubicloud.com/blog/postgresql-and-the-oom-killer-why-we-use-strict-memory-overcommit
#HackerNews #PostgreSQL #OOMKiller #MemoryManagement #StrictOvercommit #DatabasePerformance
-
8 days left to take advantage of Brent Ozar's 2026 Live Online Classes 50% discount (ends July 10).
And you can stack an extra 10% off on top of that.
Find out how to claim the exra discount: https://vladdba.com/2026/06/23/extra-10-off-brent-ozars-live-classes/
#SQLServer #DBA #BrentOzar #mssql #mssqlserver #sql #DatabasePerformance #TechTraining -
Brent Ozar's 2026 Live Online Classes are now open for registration with a 50% Launch Week discount (ends July 10).
But here’s the secret: You can stack an extra 10% off on top of that already-deep discount.
Find out how to claim the discount: https://vladdba.com/2026/06/23/extra-10-off-brent-ozars-live-classes/
#SQLServer #DBA #BrentOzar #DatabasePerformance #TechTraining -
PostgresBench: A Reproducible Benchmark for Postgres Services
https://clickhouse.com/blog/postgresbench
#HackerNews #PostgresBench #PostgresBenchmarking #DatabasePerformance #OpenSource #TechNews
-
PostgresBench: A Reproducible Benchmark for Postgres Services
https://clickhouse.com/blog/postgresbench
#HackerNews #PostgresBench #PostgresBenchmarking #DatabasePerformance #OpenSource #TechNews
-
Es gibt einen vereinfachten Satz, der mir das Thema Datenbanken seit Jahren erklärt: Die Struktur deines Datenspeichers sollte zur Struktur deiner Frage passen. Nicht zur Datenmenge, nicht zur Mode, nicht zum Hype. Zur Frage die zur Lösung deines Problems führt.
#database #coding #design #development #dev #databasearchitecture #dataanalysis #dataanalytics #question #databaseperformance #datascience #db
-
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 -
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 -
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/ -
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
-
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
-
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
-
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 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. 🚀🐘
-
🚀 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 -
🚀 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
-
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 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
-
#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 -
🚀 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
-
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
-
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 -
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 -
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
-
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
-
via @dotnet : EFCore.Visualizer – View Entity Framework Core query plan inside Visual Studio
https://ift.tt/cOdnCTJ
#EFCore #EntityFrameworkCore #VisualStudio #QueryPlan #LINQ #ORM #DatabasePerformance #SoftwareDevelopment #DeveloperTools #Coding #Programming #O…