Popular Postgresql Posts

Most Popular Postgresql Articles

PostgreSQL: Pros, Cons, and Use Cases

PostgreSQLis an open-source relational database management system (RDBMS) known for standards compliance, extensibility, and strong transactional guarantees. It implementsACIDsemantics by default and supports advanced features such as JSONB, window functions, partial indexes, and custom data types.A

Mar 02 2 database rdbms postgresql

Lead Lookup System Design (case study)

A high-scale lead management system designed to store and retrieve contact information for 200M users. The system supports lookups by phone number, email address, and SSN to resolve associated user profiles.A typical request maps a single contact identifier to exactly one user. ReplacingMergeTreeis

Jan 12 2 case-study postgresql clickhouse

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

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

This benchmark comparesPostgreSQLandClickHouseusing identical data and queries to evaluate performance in a read-heavy analytical workload. Each query was executed once. Both PostgreSQL and ClickHouse were run with default configurations (no custom tuning). The goal of this article is to demonstrate

Apr 05 1 clickhouse postgresql database

Filter posts