Thanks for the great resources on this site!

I am using the new JSONB type in PostgreSQL 9.4 and have a question about indexing. Here is my scenario. Assume I have a table named "user" with two columns: (1) "id" that is of type TEXT and is also the primary key, and (2) "setting" that is of type JSONB and contains the bulk of the payload for each row (as a JSON object). Here is my query pattern:

SELECT setting
FROM user
WHERE id IN [...]
ORDER BY setting->>'name',
         setting->>'age',
         ...

Notes about the query:

1. The WHERE clause is in the form of "id IN [...]" where the list of IDs can range from very short to very long.
2. The ORDER BY clause may contain an arbitrary list of root-level fields in the JSONB object.

In this case, how should I index the "user" table to get good query performance?

Thanks, Pai-Hung