Thanks for the insight.
Pai-Hung
Thanks for the help. So in this case, the performance of ORDER BY will not be
affected at all by whether an index is created on the jsonb "setting" field?
Pai-Hung
-Original Message-
From: "Jim Nasby"
Sent: 4/17/2015 8:59 PM
To: "Pai-Hung Chen" ;
Hi,
I am new to PostgreSQL and have a question about the new jsonb type in 9.4.
Suppose I have a table called "user" that has two columns: (1) "user_id" of
type text, also the primary key, (2) "setting" of type jsonb. With the
following query pattern:
SELECT *
FROM user
WHERE user_id IN [...]
ORD
