thank you, I will look into the work-around !
From: Tom Lane
Sent: Monday, 4 December 2017 11:39 AM
To: Yuri Budilov
Cc: rob stone; pgsql-general@lists.postgresql.org
Subject: Re: JSON out of memory error on PostgreSQL 9.6.x
Yuri Budilov writes:
> The
raw_jmcn stg_rmq_json_raw
WHERE rmq_exchange_name = 'Staging.Salesforce.Order'
AND rmq_message_id = 'd1200de2-30b0-4599-bb17-64405f45ca19';
THANK YOU
From: Yuri Budilov
Sent: Monday, 4 December 2017 11:14 AM
To: rob stone; pgsql-general@lists
FWIW.
It takes well under 1 min elapsed time to fail.
best regards and many thanks for trying to help me
From: rob stone
Sent: Monday, 4 December 2017 11:01 AM
To: Yuri Budilov; John R Pierce; pgsql-general@lists.postgresql.org
Subject: Re: JSON out of memor
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 abou
