I have a large table with multiple partitions (total size = 250 GB). The table has a column with a large json stored as a jsonb column. Users will query using criteria on certain fields (one or multiple) and also sort data based on usage.
Please suggest if its a good practice to setup BTREE indexes or do I need to evaluate GIN index on the jsonb column for better performance and management.