Postgres JSONB indexes: GIN vs BTREE on the same column

caught this in production last quarter and the answer is more boring than i expected: GIN and BTREE on the same JSONB column solve different problems, and the right choice depends on the SHAPE of your...