Pages on core PostgreSQL features that change schema design and operations: row-level security, declarative partitioning and logical replication.
Designing row-level security policies for multi-tenant SaaS and segregated data: default-deny behavior, the owner and BYPASSRLS exemptions that often leak data, FORCE ROW LEVEL SECURITY and testing policies before go-live.
Choosing range, list or hash partitioning for large tables: partition pruning, fast retention by dropping partitions, key constraints that must include the partition key, and how many partitions is too many.
Using publications and subscriptions to replicate selected tables across versions, platforms or sites, for analytics consolidation, data sharing and low-downtime migrations, and what logical replication does not carry over.
Tell us what you're working on, whether it's a deployment, an audit, a security test or a cyber range. You'll speak with an engineer who can help you scope it.