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 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
ACID Properties in DBMS with Examples (Complete Guide)

ACID Properties in DBMS with Examples (Complete Guide)

Comments
13 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
## I Built an AI Tourism Assistant for Kenya Using RAG, pgvector, and Streamlit

## I Built an AI Tourism Assistant for Kenya Using RAG, pgvector, and Streamlit

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

# Understanding Joins and Window Functions in SQL

2
Comments
7 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

5
Comments
5 min read
I Built a Free PostgreSQL Health Checker with 23 MCP Tools and CI Integration

I Built a Free PostgreSQL Health Checker with 23 MCP Tools and CI Integration

1
Comments
3 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
How to Find and Fix Missing Indexes in PostgreSQL

How to Find and Fix Missing Indexes in PostgreSQL

1
Comments
4 min read
Building in public #5: The dashboard

Building in public #5: The dashboard

1
Comments
9 min read
B+Tree vs LSM Tree: Why Your Database's Data Structure Is Everything

B+Tree vs LSM Tree: Why Your Database's Data Structure Is Everything

1
Comments 2
11 min read
Build a RAG Pipeline in Java (Text Vector LLM, No Paid APIs)

Build a RAG Pipeline in Java (Text Vector LLM, No Paid APIs)

3
Comments 2
3 min read
PostgreSQL Joins and Window Function

PostgreSQL Joins and Window Function

1
Comments
2 min read
PostGIS Spatial Indexing: Why Your Queries Are Doing Sequential Scans

PostGIS Spatial Indexing: Why Your Queries Are Doing Sequential Scans

2
Comments
3 min read
Document Databases: Be Honest

Document Databases: Be Honest

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