Tutorials
I Deleted Google Photos: All My Memories to My Own Server with Immich
I detailed my transition from Google Photos to Immich, the challenges I faced, and the specifics of photo management on my own server, step by step.
#postgresql
14 posts found.
Technology
PostgreSQL WAL Bloat Management: Reclaiming Disk Space in 4 Steps
How I tackled WAL bloat in PostgreSQL, the practical 4 steps I implemented to reclaim disk space, and critical optimization strategies...
Technology
Database Indexes: Necessary for Every Query?
I examine when database indexes are beneficial, when they hurt performance, and the right indexing strategies with real-world scenarios.
Technology
SQLite vs PostgreSQL: Which One in Production?
I compare the performance, concurrency, backup, and resource consumption differences of SQLite and PostgreSQL in production environments based on my field.
Tutorials
Vector Database Selection: Balancing Cost and Performance
Comparing PGVector, Qdrant, and Milvus to reduce memory costs and achieve performance balance in vector search projects.
Career
Database Partitioning Cost: Is It Really Worth It?
I analyze the benefits and costs of database partitioning. When should you partition, and when should you avoid it? I share my experiences.
Tutorials
Anatomy of Database Index Structures: Fundamentals of Query
A detailed examination of database index structures (B-tree, GIN, BRIN) and strategies for enhancing query performance. With real-world scenarios and concrete.
Career
Database Transaction Isolation Levels: Why They Are Always Critical?
The importance of database transaction isolation levels in real-world applications, the problems I've encountered, and how the right choice impacts my career.
Life
MVCC Misconceptions: The Indie Hacker's Database Choice Dilemma
I analyze the practical implications of MVCC, performance trade-offs, and real-world scenarios when choosing a database for indie hackers.
Tutorials
Idempotency Design in Distributed Systems: A Modern Approach
How I design idempotency keys and database strategies to resolve the 'did it go through?' chaos following API request timeouts.
Tutorials
PostgreSQL WAL Archiving and a Point-in-Time Recovery Drill
A guide to building PostgreSQL PITR practice with production discipline: WAL archiving, recovery time targets and safe restoration steps.
Tutorials
PostgreSQL HA: Failover Runbook with Patroni
Walks through quorum, replication lag, switchover/failover testing and recovery steps when running PostgreSQL high availability with Patroni, in runbook form.
Technology
Database Connection Pool Saturation and the Latency Feedback Loop
A practical framework to detect the queue, timeout, and retry loop that emerges when a connection pool clogs, and to intervene safely.
Tutorials
PostgreSQL Performance Optimization
A guide to speeding up PostgreSQL in production by measuring slow queries, finding root causes with EXPLAIN, designing the right indexes, and maintaining…