Re: [GENERAL] Postgresql jsonb

2015-08-16 Thread Deepak Balasubramanyam
is the observed performance? --- The observed performance is within my requirement. My question was aimed at getting it to stay that way and your answers have helped. Thanks again -Deepak On Fri, Aug 14, 2015 at 6:19 PM, David Rowley wrote: > On 15 August 2015 at 00:09, Deepak Ba

[GENERAL] Postgresql jsonb

2015-08-14 Thread Deepak Balasubramanyam
Hi, I have a table (20 million rows) in Postgresql 9.4 that contains a bigint id as the primary key and another column that contains jsonb data. Queries run on this table look like so... ## Query select ... from table WHERE table.column ->'item'->> 'name' = 'value' -