Forem

# 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.
PostGIS Geometry Quality: Invalid Geometries, Mixed SRIDs, and Complexity
Cover image for PostGIS Geometry Quality: Invalid Geometries, Mixed SRIDs, and Complexity

PostGIS Geometry Quality: Invalid Geometries, Mixed SRIDs, and Complexity

1
Comments
3 min read
I Removed Redis From My Stack and Used PostgreSQL for Job Queues Instead
Cover image for I Removed Redis From My Stack and Used PostgreSQL for Job Queues Instead

I Removed Redis From My Stack and Used PostgreSQL for Job Queues Instead

9
Comments
7 min read
Your Node.js App Is Probably Killing Your PostgreSQL (Connection Pooling Explained)
Cover image for Your Node.js App Is Probably Killing Your PostgreSQL (Connection Pooling Explained)

Your Node.js App Is Probably Killing Your PostgreSQL (Connection Pooling Explained)

13
Comments
6 min read
How TimescaleDB Chunks Actually Work (And Why Size Matters)

How TimescaleDB Chunks Actually Work (And Why Size Matters)

2
Comments
4 min read
Message queues in Postgres Pro: ditching external brokers for true transactional reliability

Message queues in Postgres Pro: ditching external brokers for true transactional reliability

1
Comments
5 min read
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)
Cover image for 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?
Cover image for 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)
Cover image for 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
TimescaleDB Continuous Aggregates: Real-Time vs Materialized-Only

TimescaleDB Continuous Aggregates: Real-Time vs Materialized-Only

1
Comments
4 min read
How I Built a Production RAG Pipeline with FastAPI, pgvector and Cross-Encoder Reranking
Cover image for How I Built a Production RAG Pipeline with FastAPI, pgvector and Cross-Encoder Reranking

How I Built a Production RAG Pipeline with FastAPI, pgvector and Cross-Encoder Reranking

1
Comments
8 min read
CA 27 - Isolation

CA 27 - Isolation

1
Comments 3
2 min read
Users, Roles, Groups

Users, Roles, Groups

1
Comments 1
2 min read
Anthropic recognized PostgreSQL backup tool Databasus as a valuable open source project
Cover image for 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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.