Go Developer DBMS Concepts Interview Guide

At Read Committed, each statement receives a new snapshot, so later statements can see commits made in between. Higher isolation changes the guarantees and may require retrying serialization failures. Choose isolation from the business invariant, not from an assumption that every transaction freezes all reads.

Check your understanding: Interleave two sessions and document the snapshots each statement sees.

Common trap: Treating transaction atomicity and isolation as identical.

Concept reference: PostgreSQL: transaction isolation

An index is an option, not a command. The planner considers selectivity, statistics, table size and access cost. Read estimated and actual rows, filters and scan types before changing indexes. EXPLAIN ANALYZE executes the statement, so use safe data and transaction handling for writes.

Check your understanding: Compare estimated and actual row counts on representative data.

Common trap: Forcing an index without measuring the full query.

Concept reference: PostgreSQL: reading EXPLAIN plans

Check the grain of each table and whether the join creates several rows for one order. Aggregate at the intended business grain before joining, or use the correct relationship and key. Reconcile totals using a tiny fixture containing multiple child rows and an unmatched parent.

Check your understanding: Use one order with two child records and verify the total remains correct.

Common trap: Using DISTINCT as a universal repair for a wrong join.

Concept reference: PostgreSQL: reading EXPLAIN plans

An upstream sender can remain blocked forever if nobody receives its values. Give the pipeline a cancellation path and make sends responsive to it. Decide who owns channel closure and wait for workers to finish. A buffered channel only postpones the problem when the buffer eventually fills.

Check your understanding: Cancel after the first result and check that all workers exit.

Common trap: Assuming goroutines are automatically reclaimed when a request ends.

Concept reference: Go: pipelines and cancellation

Use a bounded number of workers and a bounded work queue. Pass cancellation through the stages, propagate the first relevant error and release resources on all paths. Choose the worker count from the bottleneck and memory budget, then measure throughput and latency under a slow destination.

Check your understanding: Hold the destination slow and track goroutine count and queue depth.

Common trap: Using concurrency as a substitute for admission control.

Concept reference: Go: pipelines and cancellation

The component that knows all sends have finished should close it, often a coordinator waiting for all producers. Receivers should not close a channel while producers may still send. Make completion and cancellation separate concepts, then document whether partial results may be returned on failure.

Check your understanding: Finish producers in different orders and run cancellation tests.

Common trap: Letting every producer close the same channel.

Concept reference: Go: pipelines and cancellation

First, identify technical constraints and define measurable service objectives. Next, trace typed data, cancellation and resource ownership across concurrent service work. Contrast architectural trade-offs across write cost, read latency, consistency and operational complexity, explicitly mitigate the risk of the service restarts before the triggering allocation path is visible, and confirm system stability using a heap profile, bounded reproduction and post-fix soak-test result.

Common trap: Reaching for a specific library or framework before defining constraints, failure envelopes, and automated verification criteria.

Prioritise the failure mode exhibiting the highest user blast radius and lowest observability. Formulate an explicit containment boundary, implement idempotent retries with jitter, and establish an automated rollback threshold. Verify resilience through segmented service-level indicators, an exemplar trace and an alert threshold.

Common trap: Relying on passive monitoring dashboards without defining explicit error-budget alerts, rollback triggers, and verified recovery procedures.

Structure the response using Context-Decision-Tradeoff-Result: articulate the business and technical constraints, compare viable alternatives, explain the implementation (trace typed data, cancellation and resource ownership across concurrent service work), and document the accepted trade-off. Provide concrete proof: an explain plan, concurrency test and recovery verification.

Common trap: Speaking only in high-level abstractions or team accomplishments without detailing your direct implementation decisions, trade-offs, and measured results.

Formulate a falsifiable hypothesis from observable telemetry before altering configurations. Then inspect goroutine, task or actor ownership alongside latency and allocation profiles. Isolate the defect to the smallest reproducible boundary, validate root cause with evidence, and confirm full resolution using a before-and-after latency profile plus an explicit rollback threshold.

Common trap: Applying speculative fixes or restarting services blindly without establishing an observable signal connected to a falsifiable hypothesis.

Produce a concurrency test with cancellation evidence and a runtime profile. Document baseline assumptions, technical mechanism (trace typed data, cancellation and resource ownership across concurrent service work), rejected alternatives, bounded failure envelopes, and deterministic pass criteria. Supply reproducible verification via a compatibility contract, expand-and-contract rollout and rollback rehearsal.

Common trap: Presenting architecture diagrams or slides lacking automated unit/integration tests, observable metrics, or automated rollback configurations.