DEV Community

#postgres

Posts on tips and tricks, using and learning about PostgreSQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
SELECT * and INSERT ... SELECT Broke Production at 3am

SELECT * and INSERT ... SELECT Broke Production at 3am

Comments
3 min read
Query Fingerprints or Literal Text Diffs: A Debate for Agent SQL Regression

Query Fingerprints or Literal Text Diffs: A Debate for Agent SQL Regression

Comments
7 min read
Git Bisect for Your Data

Git Bisect for Your Data

19
Comments 2
9 min read
Menghadapi "Retry Storms": Mengapa Retry Saja Tidak Cukup dalam Sistem Terdistribusi

Menghadapi "Retry Storms": Mengapa Retry Saja Tidak Cukup dalam Sistem Terdistribusi

Comments
3 min read
The slowest requests on our API were the ones that found nothing

The slowest requests on our API were the ones that found nothing

Comments
14 min read
Your spreadsheet-database can run on hardware you already own

Your spreadsheet-database can run on hardware you already own

Comments
3 min read
What happens when the vendor changes the deal

What happens when the vendor changes the deal

Comments
3 min read
The Same Row Twice: Four Things Keyset Pagination Needs

The Same Row Twice: Four Things Keyset Pagination Needs

Comments
6 min read
A nightly pg_dump that fails with the reason, not with "Network is unreachable"

A nightly pg_dump that fails with the reason, not with "Network is unreachable"

Comments
4 min read
A test you can't run is a test you don't have

A test you can't run is a test you don't have

Comments
4 min read
Read Replicas Do Not Fix a Bad Query Plan

Read Replicas Do Not Fix a Bad Query Plan

Comments
4 min read
Your Supabase free-tier database has no backups. Here is how I fixed that in 15 minutes.

Your Supabase free-tier database has no backups. Here is how I fixed that in 15 minutes.

Comments
5 min read
CREATE INDEX CONCURRENTLY is not free, and half the time you do not need it

CREATE INDEX CONCURRENTLY is not free, and half the time you do not need it

5
Comments
4 min read
Deterministic checks for AI-written migrations

Deterministic checks for AI-written migrations

5
Comments
4 min read
One line stops a migration from taking down production. Almost nobody adds it.

One line stops a migration from taking down production. Almost nobody adds it.

5
Comments
4 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.