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.
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
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
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

Comments
12 min read
bbdump: Modern PostgreSQL Manager

bbdump: Modern PostgreSQL Manager

Comments 1
3 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)

Comments
3 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
Wait Event Heatmaps: See What PostgreSQL Is Actually Waiting On

Wait Event Heatmaps: See What PostgreSQL Is Actually Waiting On

Comments
4 min read
From SQLite to PostgreSQL: My First Integration Attempt (Failures, Learning & Direction Change)

From SQLite to PostgreSQL: My First Integration Attempt (Failures, Learning & Direction Change)

4
Comments
2 min read
Adding a Scripting Engine to a Rust CLI with Rhai

Adding a Scripting Engine to a Rust CLI with Rhai

1
Comments
6 min read
SQLite and PostgreSQL — Both in One Rust Application

SQLite and PostgreSQL — Both in One Rust Application

Comments
1 min read
Debugging PostgreSQL Query Plan Instability in Production

Debugging PostgreSQL Query Plan Instability in Production

Comments
12 min read
PostgreSQL Connection Pooling with PgBouncer: A Complete Guide

PostgreSQL Connection Pooling with PgBouncer: A Complete Guide

Comments
4 min read
Backup Is Not Enough: A PostgreSQL Recovery Story

Backup Is Not Enough: A PostgreSQL Recovery Story

Comments
7 min read
pg-warehouse - A local-first data warehouse at scale without over Engineering that mirrors PostgreSQL data - no pipelines needed!

pg-warehouse - A local-first data warehouse at scale without over Engineering that mirrors PostgreSQL data - no pipelines needed!

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