pg_repack vs VACUUM FULL: Reclaim Bloat Live
Postgres table bloat killing your query performance? Compare VACUUM FULL vs pg_repack and learn how to reclaim disk space live without any scheduled downtime.
Tag: homelab
All the articles with the tag "homelab".
pg_stat_statements: What Most Tutorials Miss
pg_stat_statements is far more than a slow query log. Here is what most tutorials skip entirely: tail latency percentiles, cache hit ratios, and WAL bloat.
Mealie vs Tandoor vs Grocy Kitchen Stack
Mealie is the polished recipe app. Tandoor is the kitchen-ops powerhouse. Grocy tracks your entire house. Here's how to pick a self-hosted kitchen stack.
Postgres EXPLAIN ANALYZE Without Crying
Learn to read Postgres EXPLAIN ANALYZE output without losing your mind. Costs, row estimates, buffer hit stats, and the index and query fixes that matter most.
pgAdmin vs Adminer vs CloudBeaver: Web UIs
pgAdmin, Adminer, or CloudBeaver — three web UIs for your databases, zero overlap in who should use them. Pick the wrong one and you'll hate your life.
Borgmatic: Borg Backup, Done Right
BorgBackup is great. Borgmatic makes you actually run it: config-driven schedules, hooks, healthchecks, and a backup system that pages you when it breaks.
PostgreSQL on ZFS: Tuning, Snapshots, Pitfalls
Run PostgreSQL 18 on ZFS for atomic snapshots, lz4 compression, and silent corruption detection. Tuning guide, backup automation scripts, and the real pitfalls.
Kasm Workspaces: Browser Desktops
Kasm Workspaces streams disposable Linux desktops and apps to your browser. Threat model, real homelab uses, and how it compares to Guacamole.
TimescaleDB Continuous Aggregates Without Pain
Stop melting your DB with Grafana queries. TimescaleDB continuous aggregates pre-roll your metrics so dashboards stay fast even at 90-day ranges without pain.
ClickHouse for Self-Hosted Logs
ClickHouse can store TB of logs on one node, query in seconds, and outscale Loki and Elasticsearch in raw cost. Here's how to wire it up with Vector and Grafana.
DuckDB for Local Analytics: Pandas on Steroids
DuckDB runs SQL directly on CSV, Parquet, and JSON files with no server and no import step required. Here is why it belongs in every home lab data toolkit.
PoE Injectors and Switches for the Home Lab
Cut rack cable clutter with Power over Ethernet. A no-nonsense guide to PoE standards, switch power budgets, and cleanly powering your home lab gear rack.