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.
What MongoDB taught me about Postgres.
Cover image for What MongoDB taught me about Postgres.

What MongoDB taught me about Postgres.

1
Comments
2 min read
TimescaleDB Compression: From 150GB to 15GB (90% Reduction, Real Production Data)
Cover image for TimescaleDB Compression: From 150GB to 15GB (90% Reduction, Real Production Data)

TimescaleDB Compression: From 150GB to 15GB (90% Reduction, Real Production Data)

8
Comments
12 min read
How we stopped ORM migrations from taking down our Postgres database

How we stopped ORM migrations from taking down our Postgres database

1
Comments
2 min read
Day 2/100: From In-Memory to PostgreSQL - Database Integration with SQLAlchemy

Day 2/100: From In-Memory to PostgreSQL - Database Integration with SQLAlchemy

2
Comments 2
9 min read
How We Built Data Retention for SendRec

How We Built Data Retention for SendRec

3
Comments
6 min read
PostgreSQL as a Vector Database: When to Use pgvector vs Pinecone vs Weaviate
Cover image for PostgreSQL as a Vector Database: When to Use pgvector vs Pinecone vs Weaviate

PostgreSQL as a Vector Database: When to Use pgvector vs Pinecone vs Weaviate

18
Comments 3
8 min read
My FOSDEM 2026 watchlist

My FOSDEM 2026 watchlist

1
Comments 1
4 min read
How I Cut API Latency by 95% by Fixing One Hidden Loop ❤️‍🔥
Cover image for How I Cut API Latency by 95% by Fixing One Hidden Loop ❤️‍🔥

How I Cut API Latency by 95% by Fixing One Hidden Loop ❤️‍🔥

2
Comments 1
11 min read
I Built a Simple Log Aggregation and Analytics tool

I Built a Simple Log Aggregation and Analytics tool

2
Comments
1 min read
3 Production Cases: How I Built AI Systems That Actually Make Money
Cover image for 3 Production Cases: How I Built AI Systems That Actually Make Money

3 Production Cases: How I Built AI Systems That Actually Make Money

1
Comments
7 min read
Building a True Lakehouse via Snowflake Postgres and pg_lake
Cover image for Building a True Lakehouse via Snowflake Postgres and pg_lake

Building a True Lakehouse via Snowflake Postgres and pg_lake

1
Comments
15 min read
Optimizing PostgreSQL in Multi-Tenant Kubernetes: Addressing Inefficiency, Resource Waste, and Scalability Challenges

Optimizing PostgreSQL in Multi-Tenant Kubernetes: Addressing Inefficiency, Resource Waste, and Scalability Challenges

2
Comments
9 min read
I Built a Free PostgreSQL Internals Course — Here's What I Learned

I Built a Free PostgreSQL Internals Course — Here's What I Learned

Comments
3 min read
The "bus factor" risk in MongoDB, MariaDB, Redis, MySQL, PostgreSQL, and SQLite
Cover image for The "bus factor" risk in MongoDB, MariaDB, Redis, MySQL, PostgreSQL, and SQLite

The "bus factor" risk in MongoDB, MariaDB, Redis, MySQL, PostgreSQL, and SQLite

4
Comments
4 min read
Updating "denormalized" aggregates with "duplicates": MongoDB vs. PostgreSQL
Cover image for Updating "denormalized" aggregates with "duplicates": MongoDB vs. PostgreSQL

Updating "denormalized" aggregates with "duplicates": MongoDB vs. PostgreSQL

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