Tag: #database
Writing on GPUs, LLMs, MLOps, Kubernetes — and mindset · 114 posts
Redis Cluster Architecture and High Availability Operations Guide: Sentinel, Cluster Mode, Memory Optimization, and Disaster Recovery
Compare Redis Standalone, Sentinel, and Cluster deployment modes. Cover Sentinel quorum-based failure detection and automatic failover, Cluster hash slots and resharding, PSYNC replication, maxmemory policies and LRU/LFU
2026-03-12 · 14 min read #database#redis#cluster#sentinel#high-availabilityPostgreSQL VACUUM, MVCC, and Bloat Optimization Guide
A comprehensive guide to PostgreSQL VACUUM, MVCC internals, and table bloat optimization for maintaining database performance.
2026-03-12 · 19 min read #database#postgresql#vacuum#mvcc#autovacuumMySQL Query Optimization Practical Guide: From EXPLAIN Analysis to Index Design and Slow Query Tuning
A comprehensive guide covering MySQL EXPLAIN/EXPLAIN ANALYZE output interpretation, B-Tree/Hash/Full-text index types, composite index design (leftmost prefix rule, covering index), query rewriting patterns (subquery to
2026-03-11 · 17 min read #database#mysql#query-optimization#explain#index-tuningPostgreSQL Advanced Indexing Guide: GIN, GiST, BRIN, and Partial Index in Practice
A deep dive into PostgreSQL advanced index types. Beyond B-tree, we explore GIN (inverted index), GiST (spatial index), BRIN (block range index), Partial/Expression Index internals, real-world use cases, EXPLAIN ANALYZE-
2026-03-10 · 16 min read #database#postgresql#indexing#gin-index#performanceCassandra Distributed Wide-Column Database Operations Guide
A comprehensive operations guide for Apache Cassandra distributed wide-column database, covering data modeling, cluster management, and performance tuning.
2026-03-09 · 28 min read #database#cassandra#distributed-database#wide-column#nosqlComplete Guide to Qdrant Vector DB Operations — From Collection Design to RAG Integration
A practical guide covering Qdrant vector DB core concepts, collection design, index strategies, payload filtering, RAG pipeline integration, and production monitoring.
2026-03-09 · 11 min read #database#qdrant#vector-database#embedding#similarity-searchTimescaleDB Time Series Database Operations Guide
A practical operations guide for TimescaleDB time series database, covering hypertable design, continuous aggregates, compression, and retention policies.
2026-03-09 · 16 min read #database#timescaledb#time-series#postgresql#2026-03HBase Practical Guide: From Large-Scale NoSQL Data Store Design to Operations
A comprehensive guide covering everything you need for real-world HBase operations, from understanding the data model and architecture to table design, RowKey strategies, read/write performance optimization, Region manag
2026-03-08 · 16 min read #hadoop#hbase#nosql#big-data#databaseDuckDB OLAP Analytics and Data Lake Guide
A guide to using DuckDB for OLAP analytics and data lake querying, covering in-process analytics, Parquet integration, and performance optimization.
2026-03-08 · 22 min read #database#duckdb#olap#analytics#data-lakeHadoop Ecosystem Operations Guide: HDFS, YARN, and MapReduce Operational Standards
Practical operational standards for running Hadoop clusters: HDFS capacity management, YARN queue design, MapReduce job tuning, monitoring, and troubleshooting.
2026-03-08 · 20 min read #hadoop#hdfs#yarn#mapreduce#databaseHBase Data Modeling Playbook: Hotspot Avoidance and Performance Stabilization
A practical playbook for HBase RowKey design patterns, hotspot detection and avoidance, Region distribution optimization, and performance stabilization in large-scale deployments.
2026-03-08 · 26 min read #hbase#nosql#data-modeling#hotspot#databaseCockroachDB Distributed SQL and NewSQL Operations Guide
A practical operations guide for CockroachDB distributed SQL database, covering cluster management, performance tuning, and disaster recovery.
2026-03-08 · 22 min read #database#cockroachdb#distributed-sql#newsql#high-availabilityTimescaleDB Time Series Database Operation Guide: From Hypertable Design to Continuous Aggregation and Compression Optimization
A comprehensive operations guide that covers TimescaleDB's Hypertable architecture and chunk management, Continuous Aggregates settings, 90% storage reduction with native compression, data retention policy, and productio
2026-03-07 · 22 min read #database#timescaledb#postgresql#time-series#hypertablePostgreSQL Partitioning Production Guide: Range, List, and Hash Strategies for Billion-Row Tables
A comprehensive guide to PostgreSQL table partitioning covering range, list, and hash strategies, partition pruning optimization, pgpartman automation, zero-downtime migration from monolithic tables, and production maint
2026-03-07 · 17 min read #database#postgresql#partitioning#performance#billion-row-tablesClickHouse Real-time OLAP and MergeTree Optimization Guide
A practical guide to ClickHouse real-time OLAP analytics and MergeTree engine optimization for high-performance analytical workloads.
2026-03-06 · 21 min read #database#clickhouse#olap#mergetree#real-time-analyticsPostgreSQL 17 Partitioning and Parallel Query Guide
A comprehensive guide to PostgreSQL 17 partitioning strategies and parallel query optimization for large-scale databases.
2026-03-06 · 15 min read #database#postgresql#partitioning#parallel-query#2026-03MySQL 8.4 InnoDB Cluster Operations and Query Optimization Handbook
A practical operations handbook covering MySQL 8.4 InnoDB Cluster setup, Group Replication operations, query optimization, index strategies, slow query analysis, and disaster recovery.
2026-03-05 · 17 min read #database#mysql#innodb-cluster#2026-03Redis 7 Cluster Operations and Memory Optimization Handbook 2026
Redis 7 Cluster Operations and Memory Optimization Handbook. Covers cluster configuration, hash slot management, memory policies, per-data-structure encoding optimization, persistence (RDB/AOF), monitoring, and disaster
2026-03-04 · 16 min read #database#2026-03OpenSearch Operations, Management, and Index Design Practical Guide 2026
A comprehensive guide for OpenSearch cluster operators covering index design, shard/replica strategies, ISM rollover lifecycle, monitoring and alerting, incident response, security hardening, and migration with practical
2026-03-04 · 22 min read #database#opensearch#elasticsearch#index-design#operations-managementPostgreSQL 17 Performance Lab: Query, Index, and Operational Tuning
PostgreSQL 17 Performance Lab: A hands-on document covering query, index, and operational tuning with Why/How/When frameworks, comparison tables, troubleshooting, practical code, and quizzes all in one place.
2026-03-04 · 9 min read #database#practical-guide#production