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
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
Indexing json b
My co-founder and me
Around postgress tables we did roam
Drinking all night
Got into a fight
and broke in the sales guy's trunk
the board had to come and take him away