Latest Postgresql Posts

Recently Added Postgresql Articles

Advanced PostgreSQL Tricks for Production Systems

Advanced PostgreSQL Tricks for Production Systems

PostgreSQL is easy to start with, but production PostgreSQL has many behaviors that developers usually learn only after slow queries, lock contention, failed migrations, or painful bulk imports.

Jun 07 1 postgresql sql database

ClickHouse vs PostgreSQL: Real-World Query Performance at Billion-Row Scale

ClickHouse vs PostgreSQL: Real-World Query Performance at Billion-Row Scale

This benchmark compares PostgreSQL and ClickHouse using identical data and queries to evaluate performance in a read-heavy analytical workload.

Apr 05 1 clickhouse postgresql database

Lead Lookup System Design (case study)

This case study explains how to design a high-scale lead lookup system for 200M users, where the main requirement is fast lookup by phone number, email address, or SSN while still supporting contact reassignment and full contact history.

Jan 12 2 case-study postgresql clickhouse

PostgreSQL: Pros, Cons, and Use Cases

PostgreSQL: Pros, Cons, and Use Cases

PostgreSQL is one of the strongest default database choices for modern backend systems. It combines relational modeling, ACID transactions, rich SQL support, JSONB, extensibility, and a mature ecosystem.

Mar 02 2 database rdbms postgresql

Filter posts