Database · Cloud · Big Data · Monitoring
Your data infrastructure,
architected.
Two senior DBAs sharing real-world knowledge from 100+ production databases — across finance, banking, telco, and logistics.
10TB+
Data managed
100+
Production databases
250GB+
Largest migration
Experienced across
PostgreSQLMySQLMongoDBRedisAWSGCPAlibaba CloudSnowflakeEDB
Articles & TutorialsReal-world knowledge.
Real-world knowledge.
Every layer of the data stack.
No theory, no fluff — just what actually works in production.
# patronictl list
+ Cluster: pg-prod
pg-01 | Leader | running
pg-02 | Replica| running
PostgreSQLHAMay 2025
PostgreSQL HA with Patroni + HAProxy + PgBouncer: complete setup guide
YJ
Yosef JeffriSELECT count(*), state
FROM pg_stat_activity
GROUP BY state;
-- active: 147
OperationsScaleApr 2025
Managing 100+ production PostgreSQL instances: patterns that scale
PW
Patria Wineka-- Pre-migration check
Schema: compatible ✓
Data types: mapped ✓
Stored procs: 12 found
MigrationOracleMar 2025
Oracle to PostgreSQL: lessons from a 250GB banking database
YJ
Yosef Jeffri# prometheus scrape
job: postgres_exporter
targets: [":9187"]
interval: 15s
MonitoringGrafanaFeb 2025
Building a complete PostgreSQL observability stack with Grafana + Prometheus
PW
Patria WinekaEXPLAIN ANALYZE
Seq Scan on orders
cost=0..89432.00
→ Index Scan: 0.08ms
PerformanceTuningJan 2025
PostgreSQL slow query analysis: from EXPLAIN to fix in production
YJ
Yosef Jeffri- name: Install PG
hosts: db_servers
apt:
name: postgresql-15
AutomationAnsibleDec 2024
Automating PostgreSQL deployments with Ansible: a production playbook
PW
Patria Wineka