Let’s talk
INSIGHTS / KNOWLEDGE, SHARED

Ideas for
your next move.

Practical thinking for teams building software, securing systems and operating modern infrastructure. Explore our engineering field notes.

500 insights · Page 7 of 42

MongoDB Shard Keys: Review Distribution and Query Routing — conceptual 3D-style vector showing Query workload, Shard key, Value ranges, Shard placement, Hot values.ENGINEERING JOURNAL ↗
Database Operations

MongoDB Shard Keys: Review Distribution and Query Routing

Compare MongoDB shard-key candidates using value distribution, growing-key behavior, and real query routing before committing to a sharding design.

Read field note ↗
MongoDB Write Concern: Handle Timeouts as Uncertain Outcomes — conceptual 3D-style vector showing Business operation, Primary write, Acknowledgment quorum, Client result, Reconciliation.ENGINEERING JOURNAL ↗
Database Operations

MongoDB Write Concern: Handle Timeouts as Uncertain Outcomes

Understand what MongoDB write-concern acknowledgments mean, why a timeout may leave a write present, and how to verify a business operation safely.

Read field note ↗
MongoDB Elections: Trace Quorum and Driver Discovery — conceptual 3D-style vector showing Application driver, Voting quorum, Candidate, Primary, Network partition.ENGINEERING JOURNAL ↗
Database Operations

MongoDB Elections: Trace Quorum and Driver Discovery

Investigate MongoDB election incidents by checking voting-member reachability, candidate eligibility, and the driver path to the replacement primary.

Read field note ↗
PostgreSQL Backup Manifests: Verify Files Before Restore — conceptual 3D-style vector showing Base backup, Manifest, File checks, Restore test, Required WAL.ENGINEERING JOURNAL ↗
Database Operations

PostgreSQL Backup Manifests: Verify Files Before Restore

Use PostgreSQL backup manifests to detect missing or changed backup files while keeping an isolated server-start and data check in the recovery workflow.

Read field note ↗
PostgreSQL Logical Replication: Map Each Privilege Hop — conceptual 3D-style vector showing Publisher role, Publication, Initial copy, Subscriber, Apply owner.ENGINEERING JOURNAL ↗
Database Operations

PostgreSQL Logical Replication: Map Each Privilege Hop

Review PostgreSQL logical-replication access separately for publisher connection, initial copy, publication ownership, and subscriber apply behavior.

Read field note ↗
PostgreSQL Concurrent Indexes: Verify Build State — conceptual 3D-style vector showing Index request, Concurrent build, Table scans, Valid index, Transaction waits.ENGINEERING JOURNAL ↗
Database Operations

PostgreSQL Concurrent Indexes: Verify Build State

Plan a PostgreSQL concurrent index build around transaction boundaries, waiting phases, resource use, and validation of the resulting index.

Read field note ↗
PostgreSQL Blocking: Trace the Session Holding the Work — conceptual 3D-style vector showing Waiting query, Blocking chain, Root transaction, Resolution, Application owner.ENGINEERING JOURNAL ↗
Database Operations

PostgreSQL Blocking: Trace the Session Holding the Work

Follow PostgreSQL blocking chains to the owning transaction, distinguish waiting work from root blockers, and choose a deliberate intervention.

Read field note ↗
PostgreSQL Timeouts: Bound Statements and Recover Transactions — conceptual 3D-style vector showing Request budget, Statement execution, Cancellation, Rollback, Application response.ENGINEERING JOURNAL ↗
Database Operations

PostgreSQL Timeouts: Bound Statements and Recover Transactions

Apply PostgreSQL statement and lock timeouts to the right workload, then verify cancellation, transaction cleanup, and application retry behavior.

Read field note ↗
PostgreSQL Pooling: Diagnose PgBouncer Queue Saturation — conceptual 3D-style vector showing Client sessions, PgBouncer queue, Server pool, PostgreSQL, Transaction duration.ENGINEERING JOURNAL ↗
Database Operations

PostgreSQL Pooling: Diagnose PgBouncer Queue Saturation

Separate queued clients from PostgreSQL backend pressure when PgBouncer becomes busy, then review pool multiplication and transaction behavior.

Read field note ↗
PostgreSQL SCRAM: Migrate Passwords with Client Evidence — conceptual 3D-style vector showing Client inventory, SCRAM support, Stored verifier, New session, HBA method.ENGINEERING JOURNAL ↗
Database Operations

PostgreSQL SCRAM: Migrate Passwords with Client Evidence

Plan a PostgreSQL SCRAM migration by checking every driver and pooler, rotating stored passwords deliberately, and testing new connections.

Read field note ↗
PostgreSQL Access Rules: Find the First Matching HBA Row — conceptual 3D-style vector showing Client address, HBA rule order, Authentication, Database, Parse validation.ENGINEERING JOURNAL ↗
Database Operations

PostgreSQL Access Rules: Find the First Matching HBA Row

Diagnose PostgreSQL access-rule surprises by following the real client address, connection type, database, and role to the first matching HBA entry.

Read field note ↗
PostgreSQL WAL Growth: Check the Archive Delivery Path — conceptual 3D-style vector showing WAL segment, Archiver, Archive store, Recovery set, Failure signal.ENGINEERING JOURNAL ↗
Database Operations

PostgreSQL WAL Growth: Check the Archive Delivery Path

Trace PostgreSQL WAL accumulation through archive statistics, destination access, and actual file delivery before changing checkpoint settings.

Read field note ↗