Search Postgresql Archives

Re: Index using in jsonb query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



This is a kind of document, there are many other kinds, with different json structure. So, a general index would be better.
But even if I create a specific index

CREATE INDEX on datatable (((jsonfield#>>'{path1,path2}')::numeric));

it isn't used in such a query; it is used in this query:

select field1,field2 from datatable where (jsonfield#>>'{path1,path2}')::numeric = 1000;

Definitely, I didn't find a way to optimize a query that checks a range in a json subfield.


On 3/11/2017 3:55 PM, SuperCiccio wrote:
Is there a way to make the following query use some sort of indexing?

select field1,field2 from datatable where (jsonfield#>>'{path1,path2}')::numeric < 1000;

if the '{path1,path2}' part is constant, I'd think you could create an index on (jsonfield #>> '{path1,path2}')::numeric


-- 
john r pierce, recycling bits in santa cruz



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux