Compare Scenarios

Migration Step 1

Both scenarios define a migration step at this stage. Content Management Platform: triggered by 'Content read API p99 > 100ms during peak traffic; PostgreSQL'. Event-Driven Analytics Pipeline: triggered by 'OLTP query performance degrading due to analytics query inte'.

Migration Step 2

Both scenarios define a migration step at this stage. Content Management Platform: triggered by 'Full-text search p99 > 500ms; inability to implement faceted'. Event-Driven Analytics Pipeline: triggered by 'Sub-minute analytics latency required; ETL scheduling overhe'.

Migration Step 3

Content Management Platform has a defined migration; Event-Driven Analytics Pipeline does not at this stage.

PostgreSQL pg_stat_statements showing > 10 distinct query patterns with high call counts from the content list API path; database queries per second growing linearly with API request rate for content list endpoints (should be sub-linear with proper batch fetching); p99 for content list API > 200ms during moderate traffic

Tier 1: N+1 Query Amplification: ORM-level N+1 patterns in content relationship traversal: author fetch, category fetch, related content fetch as independent queries per article. Recommended evolution: Audit every content API response with query logging enabled and count queries per request for each content type; implement eager loading for all included relationships (JOIN for 1:1, IN-clause batch for 1:N); validate that content list endpoints produce a fixed number of queries regardless of list size (O(1) queries, not O(N)); add a query count assertion to integration tests for content list endpoints to prevent regression .

PostgreSQL read replica CPU spike correlated exactly with publish events; Redis cache hit rate dropping to near 0% immediately after publish for popular content; content API p99 spiking from < 20ms to > 500ms during the 1–3 second window after a high-traffic content item is published

Tier 2: Cache Invalidation Thundering Herd: Cache key deletion on publish triggering simultaneous cache miss stampede for all concurrent readers of popular content. Recommended evolution: Implement cache-aside with probabilistic early expiration (PER): before the cache TTL expires, a fraction of reads proactively refresh the cache value while other reads continue serving the cached value; this eliminates the hard expiry boundary that causes simultaneous misses; alternatively, on publish, write the new content value directly into the cache key before invalidating the old one (update-in-place rather than delete-and-miss) to eliminate the invalidation gap .

pg_replication_slots shows growing pg_wal_lsn delta for CDC slot; PostgreSQL WAL directory growing faster than expected

Tier 1: CDC Slot Lag: Debezium / CDC connector not keeping up with write volume. Recommended evolution: Increase CDC connector parallelism; review filtered topics vs full-table CDC; monitor slot lag as a first-class SLA .

Kafka consumer group lag growing; analytics dashboards increasingly stale; consumer CPU and network I/O near ceiling

Tier 2: Kafka Consumer Lag: Insufficient consumer parallelism or insufficient Kafka partitions. Recommended evolution: Increase topic partition count (note: keyed messages lose ordering when partitions added); add consumer replicas up to partition count .