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.
Stop building dashboards. Start asking questions.

Stop building dashboards. Start asking questions.

Comments
2 min read
XID Wraparound Recovery: The Runbook Your Database Needs Before It's Too Late

XID Wraparound Recovery: The Runbook Your Database Needs Before It's Too Late

Comments
4 min read
MyDBA.dev vs pganalyze: Which PostgreSQL Monitor Should You Choose?

MyDBA.dev vs pganalyze: Which PostgreSQL Monitor Should You Choose?

Comments
4 min read
How to Set Up a Staging Database from Production PostgreSQL (2026 Guide)

How to Set Up a Staging Database from Production PostgreSQL (2026 Guide)

Comments
7 min read
Complete Guide to CloudNativePG 1.29 + PostgreSQL 18 — Production Kubernetes Database Operator Setup

Complete Guide to CloudNativePG 1.29 + PostgreSQL 18 — Production Kubernetes Database Operator Setup

Comments
5 min read
I Ditched Prisma for Raw SQL (And My Queries Got 10x Faster)

I Ditched Prisma for Raw SQL (And My Queries Got 10x Faster)

10
Comments 2
6 min read
I got tired of migration tools that do too much — so I built one that does exactly one thing

I got tired of migration tools that do too much — so I built one that does exactly one thing

Comments
1 min read
Optimizing Time Series Data Storage and Querying: Migrating `candle_data` from PostgreSQL to QuestDB for Enhanced Performance

Optimizing Time Series Data Storage and Querying: Migrating `candle_data` from PostgreSQL to QuestDB for Enhanced Performance

Comments
10 min read
What happens when every developer on your team can query production (safely)

What happens when every developer on your team can query production (safely)

Comments
2 min read
Kanel v4: Generate Markdown from Postgres

Kanel v4: Generate Markdown from Postgres

Comments
3 min read
Finding Hidden Bottlenecks in Go Apps: A Lazy, Hacky, and Bruteforce Method

Finding Hidden Bottlenecks in Go Apps: A Lazy, Hacky, and Bruteforce Method

Comments
4 min read
7 PostgreSQL extensions that will supercharge your database in 2026

7 PostgreSQL extensions that will supercharge your database in 2026

Comments
9 min read
The Open-Source Alternative to Oracle 26ai: Why PostgreSQL is All You Need

The Open-Source Alternative to Oracle 26ai: Why PostgreSQL is All You Need

4
Comments
5 min read
Why I'm Building NodeDB

Why I'm Building NodeDB

Comments
5 min read
PostgreSQL logical replication — 5 steps to set up real-time data sync across servers

PostgreSQL logical replication — 5 steps to set up real-time data sync across servers

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