Database Insights

PostgreSQL 16 introduced logical replication from standbys, pg_stat_io, SQL/JSON constructors, COPY improvements, and pg_stat_checkpointer. Full DBA upgrade guide.

Use PostgreSQL tablespaces to distribute tables and indexes across NVMe, SSD, and archive storage. Covers creation, ALTER TABLE SET TABLESPACE, monitoring, and backup.

Run PostgreSQL schema changes without locking: CREATE INDEX CONCURRENTLY, NOT VALID constraints, expand-contract column type changes, and lock_timeout. Covers pg_repack for table rewrites.

Migrate Oracle to PostgreSQL using ora2pg. Covers NUMBER→NUMERIC, DATE gotchas, PL/SQL→PL/pgSQL conversion, sequences, DUAL, NULL handling, and validation steps.

Configure Patroni to use Consul instead of etcd as its DCS for PostgreSQL HA. Covers Consul setup, patroni.yml, service discovery, HAProxy routing, and failover testing.

Use pg_cron to schedule SQL jobs inside PostgreSQL. Covers installation, cron syntax, partition maintenance, materialized view refresh, job monitoring, and RDS setup.

Learn how to convert a standalone PostgreSQL instance to a Patroni high-availability cluster with etcd. Step-by-step guide covering installation, configuration, and failover testing.

Learn exactly when to switch Aurora from Standard to I/O-Optimized storage — with the break-even formula and a worked cost example using db.r6g.8xlarge with 10 TB storage.

Run SQL Server on Linux in production — container vs bare metal, performance parity, AG on Pacemaker, and monitoring

Migrate Oracle workloads to SQL Server — data type mapping, PL/SQL conversion, SSMA tooling, and validation strategies

Use SQL Server Query Store to catch bad execution plans, force stable plans, and automate query performance regression alerts

Configure SQL Server Always On AG — listener routing, synchronous vs asynchronous commit, failover policy, and monitoring