N-gated Hacker News2d ago
🚀 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 Day4d ago

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

Prague PostgreSQL Dev DayJan 18

#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

Prague PostgreSQL Dev DayJan 18

#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

N-gated Hacker NewsDec 23
🚀 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
Instant database clones with PostgreSQL 18

Learn how to clone PostgreSQL databases instantly using reflinks. Turn slow template copies into milliseconds with PostgreSQL 18's new file copy options.

boringSQL | Supercharge your SQL & PostgreSQL powers
Hacker NewsDec 12

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 Superpower: Virtual Columns + Indexing - DB Pro Blog

One of the coolest patterns in SQLite—store raw JSON documents, create virtual generated columns using json_extract, add indexes, and query JSON at full B-tree index speed.

Hacker NewsDec 3

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

This blog talks aggregations in PostgreSQL version 19. Read in, check use cases and learn more about the feature.

CYBERTEC PostgreSQL | Services & Support
N-gated Hacker NewsDec 2
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
100000 TPS over a billion rows: the unreasonable effectiveness of SQLite

A blog mostly about Clojure programming

Hacker NewsOct 24

Benchmarking Postgres 17 vs. 18

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

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

Benchmarking Postgres 17 vs 18 — PlanetScale

Postgres 18 brings a significant improvement to read performance via async I/O and I/O worker threads. Here we compare its performance to Postgres 17.

Hacker NewsOct 18

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? (And Why You Should Care) | Crunchy Data Blog

A query to find out if Postgres is read heavy or write heavy and tips for optimizing Postgres for both read and write workloads.

Crunchy Data