How Postgres DELETE can actually scale(dbos.dev)
22 points by KraftyOne | 6 comments
A DBOS blog post by Peter Kraft and Qian Li explaining how to make large-scale DELETE operations in Postgres perform and scale well.
#database-performance on Hacker News
13 stories tagged database-performance, newest first.
PGO or not PGO this is the dilemma. Step 2(percona.com)
18 points by hnp9j9qtda | 3 comments
A Percona blog post, the second in a series, on whether profile-guided optimization (PGO) compiler builds improve MySQL database performance.
Postgres isn't slow, your storage is(clickhouse.com)
146 points by saisrirampur | 148 comments
ClickHouse blog recap of a POSETTE 2026 talk arguing PostgreSQL performance at scale is limited by storage, with benchmarks and a local-NVMe production architecture.
The startup's Postgres survival guide(hatchet.run)
474 points by abelanger | 206 comments
A Hatchet blog post offering startups a guide to keeping their Postgres databases from falling over under load.
Unconventional PostgreSQL Optimizations(hakibenita.com)
398 points by haki | 63 comments
Blog post by Haki Benita presenting unconventional, creative techniques for speeding up queries in PostgreSQL beyond standard indexing and query rewrites.
Avoid UUID Version 4 Primary Keys in Postgres(andyatkinson.com)
336 points by pil0u | 370 comments
Blog post by Andrew Atkinson arguing against using random UUID version 4 values as primary keys in PostgreSQL, covering performance issues and alternatives.
100k TPS over a billion rows: the unreasonable effectiveness of SQLite(andersmurphy.com)
344 points by speckx | 124 comments
Blog post by Anders Murphy benchmarking SQLite at 100k transactions per second over a billion rows, arguing its embedded single-writer design helps it scale.
Making Postgres slower(byteofdev.com)
320 points by AsyncBanana | 35 comments
A ByteofDev blog post humorously exploring how to tune PostgreSQL configuration settings to make the database as slow as possible.
Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O(pganalyze.com)
531 points by lfittl | 140 comments
A pganalyze blog post by Lukas Fittl explaining the new asynchronous I/O subsystem for disk reads in the Postgres 18 beta and its performance implications.
PostgreSQL Full-Text Search: Fast When Done Right (Debunking the Slow Myth)(blog.vectorchord.ai)
377 points by VoVAllen | 80 comments
A VectorChord blog post arguing that PostgreSQL full-text search is fast when configured correctly, debunking claims that it is slow.
In Search of a Faster SQLite(avi.im)
336 points by avinassh | 140 comments
Blog post with notes on the paper "Serverless Runtime / Database Co-Design With Asynchronous I/O", the research behind Limbo, a Rust rewrite of SQLite.
SSDs have become fast, except in the cloud(databasearchitects.blogspot.com)
550 points by greghn | 370 comments
Database Architects blog post arguing that local SSD throughput has exploded with PCIe 5.0 while cloud instance storage performance has stagnated.
JSONB has landed(sqlite.org)
579 points by nalgeon | 181 comments
SQLite forum post by Richard Hipp announcing JSONB, a binary rewrite of SQLite's JSON functions that landed on trunk and can be several times faster.