Embed Notice
HTML Code
Corresponding Notice
- Embed this notice
on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ (lain@lain.com)'s status on Thursday, 28-Dec-2023 20:35:56 JSTon-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ @Moon depending on the situation this can lead to erratic performance because i think postgresql still can't properly get statistics for the whole jsonb object (see https://blog.anayrat.info/en/2017/11/26/postgresql-jsonb-and-statistics/). But if you make a functional index on it it's exactly the same as having a column.