Home/Tags/DevOps

#DevOps

Collection

This aggregates CodeNodeX AI community articles and discussions related to DevOps, covering concept explanations, tool comparisons, engineering practices, common issues, and indie hacking experience.

If you're researching DevOps, start with high-quality long-form articles, then join post discussions for a complete understanding-to-practice path.

@admin·20 min read·Cloud Native

Kubernetes ConfigMaps and Secrets: Configuration and Secret Management

Configuration should not be hard-coded into images: ConfigMaps store nonsensitive settings, while Secrets store credentials. This article covers creation and mounting, env vs. volume, base64 and encryption with etcd, KMS, and external operators, ConfigMap hot updates and the subPath trap, and production secret management with External Secrets Operator.

#DevOps♥ 1870 comments
@admin·16 min read·Cloud Native

PostgreSQL Statistics and the Query Planner

Why does PostgreSQL choose a Seq Scan over an Index Scan? Its planner uses statistics to estimate which is faster, and inaccurate statistics produce bad plans. This article explains how ANALYZE collects statistics, how they guide planning, when stale data causes slow queries, and how to intervene with statistics targets and extended statistics.

#DevOps♥ 1880 comments
@admin·19 min read·Cloud Native

Database Replication Lag: Causes, Monitoring, and Mitigation

After read/write splitting, users "can't read what they just wrote"—this is replication lag. This article explains why lag occurs (async replication network/disk/transactions), how to monitor it (pg_stat_replication), how to mitigate it (read/write consistency window/synchronous replication/reading the primary on critical paths), and the application-level

#DevOps♥ 1930 comments
@admin·18 min read·Cloud Native

PostgreSQL TOAST: Transparent Compression for Oversized Values

A PostgreSQL row is limited to 8KB, so how can TEXT or JSONB hold megabytes of data? TOAST automatically compresses oversized values and moves them to a separate table. This guide explains its four strategies (PLAIN/EXTERNAL/EXTENDED/MAIN), query-performance costs, when to tune storage, and best practices for designing large fields.

#DevOps♥ 1940 comments