Re: Error creating gin index on jsonb columns

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Glenn Zhu <gzhu(at)medallia(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Error creating gin index on jsonb columns
Date: 2015-10-16 13:28:27
Message-ID: 455.1445002107@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Glenn Zhu <gzhu(at)medallia(dot)com> writes:
> We are getting an error on the following statement:
> CREATE INDEX CONCURRENTLY customer_jsonb_fields_idx ON customer USING gin
> (jsonb_fields jsonb_path_ops);

> ERROR: invalid memory alloc request size 2013265920

> Anyone know what is causing it?

Sounds like a bug from here. What PG version is this exactly? If it's
not the latest minor releases, try updating. If it's still there, see if
you can extract a test case that you can share.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephen Frost 2015-10-16 13:34:59 Re: [PATCH v3] GSSAPI encryption support
Previous Message kolo hhmow 2015-10-16 13:11:39 Re: pam auth - add rhost item