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.
How to upgrade Postgres to a new major version in Docker

How to upgrade Postgres to a new major version in Docker

2
Comments 4
12 min read
Optimizing High-Volume Financial Ledger Queries in PostgreSQL

Optimizing High-Volume Financial Ledger Queries in PostgreSQL

Comments
2 min read
How a Zero-Downtime Table Swap Silently Dropped Orders From Postgres Logical Replication for 91 Hours

How a Zero-Downtime Table Swap Silently Dropped Orders From Postgres Logical Replication for 91 Hours

Comments
6 min read
Disaster Recovery: Restoring PostgreSQL on Amazon RDS

Disaster Recovery: Restoring PostgreSQL on Amazon RDS

Comments
3 min read
Why Cassandra fits high-frequency writes better than Postgres

Why Cassandra fits high-frequency writes better than Postgres

1
Comments 1
4 min read
Database Schema Diagram Tool: 5 Ways to Visualize PostgreSQL

Database Schema Diagram Tool: 5 Ways to Visualize PostgreSQL

Comments
3 min read
Building a Webhook Queue on PostgreSQL: Why We Ditched Redis for Shopify Webhook Processing

Building a Webhook Queue on PostgreSQL: Why We Ditched Redis for Shopify Webhook Processing

Comments
12 min read
UUIDv7 and the end of the random primary key

UUIDv7 and the end of the random primary key

Comments
9 min read
Just use Postgres, until it actually hurts

Just use Postgres, until it actually hurts

Comments
6 min read
RAG is a search problem wearing a costume

RAG is a search problem wearing a costume

Comments
8 min read
Our entire production schema is one table and 33 lines, and it has not changed in 71 days

Our entire production schema is one table and 33 lines, and it has not changed in 71 days

Comments
7 min read
Why Our Oracle Migration Tool Won't Connect to Your Database

Why Our Oracle Migration Tool Won't Connect to Your Database

Comments
3 min read
A campaign that has searched every keyword gets eight new ones, and the worst eight switch off

A campaign that has searched every keyword gets eight new ones, and the worst eight switch off

Comments
7 min read
Your Backups Don't Exist Until You've Restored One: A Monthly Drill for a Solo SaaS

Your Backups Don't Exist Until You've Restored One: A Monthly Drill for a Solo SaaS

Comments
5 min read
PostgreSQL 19's sequence replication only catches up when you tell it to

RC1 testing reveals failover risks remain

PostgreSQL 19's sequence replication only catches up when you tell it to

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