Skip to content
Snippets Groups Projects
  • Andrew Dunstan's avatar
    1a4174a4
    Improve the efficiency of certain jsonb get operations. · 1a4174a4
    Andrew Dunstan authored
    Instead of iterating over jsonb structures, use the inbuilt functions
    findJsonbValueFromContainerLen() and getIthJsonbValueFromContainer() to
    extract values directly. These functions use algorithms that are O(n log
    n) and O(1) respectively, whereas iterating is O(n), so we should see
    considerable speedup here.
    
    Teodor Sigaev.
    1a4174a4
    History
    Improve the efficiency of certain jsonb get operations.
    Andrew Dunstan authored
    Instead of iterating over jsonb structures, use the inbuilt functions
    findJsonbValueFromContainerLen() and getIthJsonbValueFromContainer() to
    extract values directly. These functions use algorithms that are O(n log
    n) and O(1) respectively, whereas iterating is O(n), so we should see
    considerable speedup here.
    
    Teodor Sigaev.