Posted on Stack Overflow, sadly no replies, so trying here....
CREATE TABLE X AS
SELECT json_array_elements(json_rmq -> 'orders'::text) AS order
FROM table_name
WHERE blah;
I get out of memory error.
Is there anything I can do to unpack the above?
The JSON column is about ~5 MB and it has about ~150,000 array row elements in 'orders' above.
I tried work_mem values up to ~250MB and it did not help, the query takes about same time to fail.
I guess this parameter does not help JSON processing.
If there another parameter I can try? Something else?
I don't have control of the size of the JSON payload, it arrives, we store it in a JSON column and then we need to crack it open.
Many thanks!