[justkez]

I'm implementing some faceting in a project I'm working on. I have some nested `jsonb` columns which include categorical variables (to quote this article).

The table is only 5 million rows and isn't likely to grow significantly, but it is not very wide.

The performance is okay and I was about to experiment with flattening out the table (putting all categorical vars into their own columns) and indexing that way vs. indexing JSONb paths.

I'm not super familiar with the postgres internals to know if this is better or worse so wondering if anyone could share any similar experience?!