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.
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
Why Your Postgres Table Keeps Growing Even Though You're Deleting Rows

Why Your Postgres Table Keeps Growing Even Though You're Deleting Rows

5
Comments 8
7 min read
From MySQL to PostgreSQL: a much lighter server

From MySQL to PostgreSQL: a much lighter server

Comments
2 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
How to get a managed PostgreSQL database for about $2 a month

How to get a managed PostgreSQL database for about $2 a month

2
Comments
6 min read
Database Indexing – Part 3: Understanding Composite Indexes in PostgreSQL

Database Indexing – Part 3: Understanding Composite Indexes in PostgreSQL

Comments
11 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
Experiments in Software Factories #1: Production app in 40 minutes

Experiments in Software Factories #1: Production app in 40 minutes

5
Comments
9 min read
Why Did Supabase Pause My Project? How to Restore It and Stop It Happening Again

Why Did Supabase Pause My Project? How to Restore It and Stop It Happening Again

1
Comments 2
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
FR24/Django4/postgres/openstreetmap live flight tracker

FR24/Django4/postgres/openstreetmap live flight tracker

Comments
1 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
What 40 agent-written migrations got wrong

What 40 agent-written migrations got wrong

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