at last last last place we had one big old table of jsonb and it was fine, but after i left, they moved some of the fields into columns to speed up scans
Comments
Log in with your Bluesky account to leave a comment
i want to do something like create index whatever on table (column->>'field'), i figured that would be roughly equivalent to pulling things out into columns
my person rule of thumb is "stick indexed columns and foreign keys in their own field if they're in every row" but yeah you can always add a column later, backfill, and create index concurrently
Comments