Embed Notice
HTML Code
Corresponding Notice
- Embed this notice
lainy (lain@lain.com)'s status on Thursday, 28-Dec-2023 20:35:56 JST lainy
@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.