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: Transactions, Locks, and Why Serializable Fails

PostgreSQL: Transactions, Locks, and Why Serializable Fails

1
Comments
7 min read
MySQL vs MariaDB vs PostgreSQL for Laravel (2026)

MySQL vs MariaDB vs PostgreSQL for Laravel (2026)

Comments
7 min read
Neon Postgres Review: Is Serverless PostgreSQL Ready for Production?

Neon Postgres Review: Is Serverless PostgreSQL Ready for Production?

Comments 1
13 min read
PostgreSQL EXPLAIN ANALYZE: Reading Query Plans Like a Pro

PostgreSQL EXPLAIN ANALYZE: Reading Query Plans Like a Pro

Comments
4 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
CA 27 - Isolation

CA 27 - Isolation

1
Comments 3
2 min read
Anthropic recognized PostgreSQL backup tool Databasus as a valuable open source project

Anthropic recognized PostgreSQL backup tool Databasus as a valuable open source project

1
Comments
4 min read
IVFFlat vs HNSW in pgvector: Which Index Should You Use?

IVFFlat vs HNSW in pgvector: Which Index Should You Use?

1
Comments
4 min read
Managed vs Self Hosted Database: Which Is Better for Your Startup?

Managed vs Self Hosted Database: Which Is Better for Your Startup?

Comments
8 min read
Optimizing Continuous Aggregate Performance for Large Datasets

Optimizing Continuous Aggregate Performance for Large Datasets

Comments
4 min read
How to Monitor PostgreSQL metrics with OpenTelemetry

How to Monitor PostgreSQL metrics with OpenTelemetry

Comments
13 min read
PostgreSQL monitoring: Best practices and essential performance metrics

PostgreSQL monitoring: Best practices and essential performance metrics

Comments
3 min read
How a 58-Table Subscription Crashed the Entire Replication Cluster

How a 58-Table Subscription Crashed the Entire Replication Cluster

2
Comments
4 min read
CREATE INDEX CONCURRENTLY: The Complete PostgreSQL Guide

CREATE INDEX CONCURRENTLY: The Complete PostgreSQL Guide

1
Comments
5 min read
How to Break Your PostgreSQL IIoT Database and Learn Something in the Process

How to Break Your PostgreSQL IIoT Database and Learn Something in the Process

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