Don't rely on IF NOT EXISTS for concurrent index creation in PostgreSQL(shayon.dev)

60 points by shayonj 2 years ago | 43 comments

Unconventional PostgreSQL Optimizations(hakibenita.com)

398 points by haki 9 months ago | 63 comments

Blog post by Haki Benita presenting unconventional, creative techniques for speeding up queries in PostgreSQL beyond standard indexing and query rewrites.

PostgreSQL Benchmark: AWS RDS vs. Self-Hosted on Hetzner (2026)(hostim.dev)

17 points by pv1337 3 months ago | 1 comments

PSA: SQLite WAL checksums fail silently and may lose data(avi.im)

266 points by avinassh 1 year ago | 121 comments

Short-Circuiting Correlated Subqueries in SQLite(emschwartz.me)

6 points by emschwartz 10 months ago | 0 comments

How to Optimize MongoDB Query Performance with Indexes(visualeaf.com)

13 points by RoxiHaidi 5 months ago | 2 comments