3 · COMPARISON · THE MAIN QUESTION OF THE CASE STUDY
← Lesson 1: Criteria
▶ Run: P8
What NOT to Transfer
DATA
CANDIDATE
WHY
players, purchases, inventory
PostgreSQL
Money and Accounting: FK, CHECK, and Transactions—the Norm, Not the Exception
matches, match_participants
PostgreSQL
The structure is stable and is processed using aggregates and JOINs
item_configs, events_config
MongoDB or jsonb
Compare models, features, specifications, and operating costs
session, profile cache, leaderboard
Redis or PostgreSQL
TTL and structures are convenient; check the load and loss
An argument that doesn't count
"I chose MongoDB because of its flexible structure."
PostgreSQL has jsonb with CHECK constraints, GIN indexes, and expression-based indexes (P8). The following criteria are taken into account: specific catalog operations, performance testing on the same data and indexes, an independent owner, and a growth plan.
"We'll leave it as jsonb in PostgreSQL" — the complete answer. If there's a measurable review criterion nearby: "p95 catalog time exceeds 50 ms on the target workload after index tuning — let's compare it in the lab."
▶ P15: Outbox