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 Optimize PostgreSQL 18 Performance with PgBouncer 1.23 and Redis 8.1: 2026 Guide

How to Optimize PostgreSQL 18 Performance with PgBouncer 1.23 and Redis 8.1: 2026 Guide

Comments
15 min read
Debugging Postgres LISTEN/NOTIFY Is Finally Pleasant

Debugging Postgres LISTEN/NOTIFY Is Finally Pleasant

Comments
5 min read
How I Fixed a Correlated Subquery That Was Behaving Like an N+1 Problem in Production

How I Fixed a Correlated Subquery That Was Behaving Like an N+1 Problem in Production

Comments
2 min read
Building a Horse Racing AI Pipeline: PostgreSQL + Claude for Automated Race Predictions

Building a Horse Racing AI Pipeline: PostgreSQL + Claude for Automated Race Predictions

1
Comments
3 min read
PostgreSQL Replication Slots: Create, Monitor & Troubleshoot

PostgreSQL Replication Slots: Create, Monitor & Troubleshoot

Comments
3 min read
Why PostgreSQL Ignores Your Index

Why PostgreSQL Ignores Your Index

Comments
9 min read
Semantic Search in Laravel: Building a Vector-Powered Product Discovery Engine

Semantic Search in Laravel: Building a Vector-Powered Product Discovery Engine

Comments
5 min read
Why Redis Cannot Share the Truth with Postgres - The architecture mistake that will oversell your tickets

Why Redis Cannot Share the Truth with Postgres - The architecture mistake that will oversell your tickets

Comments
9 min read
Patterns for Postgres Traffic Control

Patterns for Postgres Traffic Control

Comments
9 min read
Neon vs Supabase (2026) — Database or Backend? The Real Tradeoffs

Neon vs Supabase (2026) — Database or Backend? The Real Tradeoffs

Comments
4 min read
Introduction to Databases with SQL

Introduction to Databases with SQL

2
Comments
6 min read
Connecting PostgreSQL to Power BI for Data Analysis

Connecting PostgreSQL to Power BI for Data Analysis

3
Comments
7 min read
Managing Academic Data: A Practical Application of SQL in PostgreSQL

Managing Academic Data: A Practical Application of SQL in PostgreSQL

Comments
4 min read
First Week Reflections on SQL

First Week Reflections on SQL

Comments
2 min read
How a Bash Quoting Artifact Broke Our Production PostgreSQL Deploy

How a Bash Quoting Artifact Broke Our Production PostgreSQL Deploy

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