Re: JSON out of memory error on PostgreSQL 9.6.x

[John R Pierce <pierce@xxxxxxxxxxxx>]

On 12/3/2017 3:18 PM, Yuri Budilov wrote:

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.

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