10
Accepted answer
Worth measuring the serialized size before choosing broadcast.
This worked in dev on sample data but fails at full volume. Details:
Context: Guaranteeing order per user_id across partitions
Happy to share schema snippets or metrics if useful.
Accepted answer
Worth measuring the serialized size before choosing broadcast.
This matches our runbook for skewed keys.
Quick plain-English version: the database is doing more work than it needs to because it can't tell in advance which rows actually match. An index is basically a shortcut list so it doesn't have to check every single row.
Quick plain-English version: the database is doing more work than it needs to because it can't tell in advance which rows actually match. An index is basically a shortcut list so it doesn't have to check every single row.
Sign in to reply.