On 12/3/2017 3:18 PM, Yuri Budilov wrote:
|CREATETABLEX ASSELECTjson_array_elements(json_rmq ->'orders'::text)ASorderFROMtable_name WHEREblah;|I get out of memory error.
are you sure thats a postgres error ? are you doing this in psql, or what sort of application environment ?
how many rows does 'blah' match ? what is... SELECT pg_column_size(json_array_elements(json_rmq -> 'orders'::text)) FROM table_name WHERE blah; ? -- john r pierce, recycling bits in santa cruz
