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.
PostgreSQL JSONB: When to Use It and How to Query It Like a Pro

PostgreSQL JSONB: When to Use It and How to Query It Like a Pro

Comments
3 min read
PostgreSQL Internals: Inside the Storage Engine

PostgreSQL Internals: Inside the Storage Engine

1
Comments
9 min read
Why Your TimescaleDB Compression Ratio Is Bad (And How to Fix It)

Why Your TimescaleDB Compression Ratio Is Bad (And How to Fix It)

Comments
4 min read
How to use pg_dump for PostgreSQL backups — the complete 2026 tutorial

How to use pg_dump for PostgreSQL backups — the complete 2026 tutorial

Comments
9 min read
I deleted my entire AI microservice and just used Postgres (here is why) 🐘⚡

I deleted my entire AI microservice and just used Postgres (here is why) 🐘⚡

1
Comments
3 min read
Understanding TimescaleDB Background Workers and Jobs

Understanding TimescaleDB Background Workers and Jobs

1
Comments
4 min read
Running PostgreSQL on AKS with Premium SSD (StatefulSet + Azure Managed Disk)

Running PostgreSQL on AKS with Premium SSD (StatefulSet + Azure Managed Disk)

1
Comments
3 min read
Building a Production-Ready Full Stack App with Flutter, Django & PostgreSQL

Building a Production-Ready Full Stack App with Flutter, Django & PostgreSQL

3
Comments 1
2 min read
Understanding Joins and Window Functions in SQL

Understanding Joins and Window Functions in SQL

2
Comments
5 min read
Building AI-Powered Search for Your App: Vector Search, Hybrid Search, and Semantic Ranking from Scratch

Building AI-Powered Search for Your App: Vector Search, Hybrid Search, and Semantic Ranking from Scratch

1
Comments 1
13 min read
Connecting Power BI to a SQL Database

Connecting Power BI to a SQL Database

5
Comments 1
5 min read
Clustered vs Non-Clustered Index in SQL(Complete Guide with Examples)

Clustered vs Non-Clustered Index in SQL(Complete Guide with Examples)

2
Comments
5 min read
How I Took Down Prod With a 400ms Migration (And The Playbook I Use Now)

How I Took Down Prod With a 400ms Migration (And The Playbook I Use Now)

Comments
8 min read
pgvector Distance Functions: Cosine vs L2 vs Inner Product

pgvector Distance Functions: Cosine vs L2 vs Inner Product

1
Comments 1
3 min read
PostgreSQL XID Wraparound: What It Is and How to Prevent It

PostgreSQL XID Wraparound: What It Is and How to Prevent It

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