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

Struggling with slow PostgreSQL performance?

pg_gather helps you uncover what’s really going on before it impacts users.

Join Mughees Ahmed from Stormatics on 29 Oct 2025 at 3 PM GMT for “PostgreSQL Troubleshooting Made Easy with pg_gather.”

Learn how to find bloat, bad indexes, blocking sessions, and more, all with one tool.

Register now: https://resources.stormatics.tech/webinar-postgresql-troubleshooting-made-easy-with-pg_gather

#PostgreSQL #pg_gather #DatabasePerformance

Struggling with slow queries in Odoo? Discover query optimizations in Odoo 17–19 to boost PostgreSQL performance!

✅ Reduce SQL statements
✅ Smarter domain handling
✅ GROUPING SETS for pivots
✅ Declarative indexes & constraints

Speed up queries & reduce server load: https://stormatics.tech/blogs/query-optimizations-in-odoo-versions-17-19-for-faster-postgresql-performance

#Odoo #DatabasePerformance #PostgreSQL

A SQL Heuristic: Ors Are Expensive

https://ethanseal.com/articles/ors-are-expensive

#HackerNews #SQL #Heuristic #Ors #Are #Expensive #DataOptimization #DatabasePerformance #QueryEfficiency

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…

Database Branching: The Antidote to Production Surprises

Every CTO knows this story. The release passes every automated test, the staging sign-off is green, and confidence is high. Yet hours after deployment, dashboards flare red. Performance tanks, customer-facing features break, or worse, critical data goes missing. The culprit, more often than not, is a database change such as migration, schema modification, or index update that behaved perfectly in pre-production but exposed hidden problems in production.

This isn’t a rare edge case. It’s […]

https://www.simplyblock.io/blog/database-branching-the-antidote-to-production-surprises/

#PostgreSQL <s>18</s>19 is coming with #NUMA awareness, they say there are 2x - 4x speed difference, that is massive.

https://www.postgresql.org/message-id/51e51832-7f47-412a-a1a6-b972101cc8cb%40vondra.me

#performance #databaseperformance

Benchmarking Simplyblock Storage on ClickBench with PostgreSQL and DuckDB

As storage demands scale and workloads become increasingly performance-sensitive, the right infrastructure choices can drive massive gains in both throughput and efficiency. At simplyblock, we set out to validate the performance of our storage layer using the industry-standard ClickBench benchmark suite.

Thanks to the vast number of available databases supported databases, ClickBench is a perfect tool to run database benchmarks and adjust them to new environments quickly. We tested two […]

https://www.simplyblock.io/blog/simplyblock-clickbench-benchmark/

🎉 Our Postgres event with core team member Bruce Momjian is in full swing at the VSHNtower!
Great insights, deep dives into performance tuning, and awesome community vibes here in Zürich.

🧠 Who else loves geeking out over databases? #PostgreSQL #Postgres #VSHN #DatabasePerformance #EDB #OpenSource

Jepsen: TigerBeetle 0.16.11

https://jepsen.io/analyses/tigerbeetle-0.16.11

#HackerNews #Jepsen #TigerBeetle #Analysis #DistributedSystems #DatabasePerformance

Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O

https://pganalyze.com/blog/postgres-18-async-io

#HackerNews #Postgres18 #AsynchronousIO #DiskReads #DatabasePerformance

Memory Size Matters to PostgreSQL

https://pgdba.org/post/2025/04/size_matter/

#HackerNews #MemorySize #PostgreSQL #DatabasePerformance #TechInsights #SQLOptimization

@Meesho_Official migrated to Dragonfly and saw 50% lower latency and a 60% cost reduction. Read our case study to learn how they serve 175 million users with a lightning-fast user experience. https://www.dragonflydb.io/blog/meesho-migrates-from-redis-to-dragonfly-cuts-latency-and-costs #DragonflyDB #DatabasePerformance
https://www.dragonflydb.io/blog/meesho-migrates-from-redis-to-dragonfly-cuts-latency-and-costs

🎉 Wow, thrilling news alert! 💥 You can now choose between data integrity and a blazing fast database—because who needs reliable data when you can have SPEED? 🚀📉 Hint: you might want to keep a therapist on speed dial when your data inconsistencies start haunting you at night. 😅📊
https://www.shayon.dev/post/2025/75/selective-asynchronous-commits-in-postgresql-balancing-durability-and-performance/ #dataintegrity #speedoverreliability #databaseperformance #technews #humor #HackerNews #ngated

Database Deadlocks: Understanding and Preventing Conflicts in Different DBMS
Database deadlocks can cripple your database performance! Learn how they happen and how to prevent them in various DBMS. Strategies for avoiding these conflicts are crucial for a smooth-running database. #DatabaseDeadlocks #DBMS #DeadlockPrevention #ConcurrencyControl #SQL #DatabasePerformance

https://tech-champion.com/application-support/database-deadlocks-understanding-and-preventing-conflicts-in-different-dbms...