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:43:35
Message-ID: 821.1445003015@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 currently running 9.4.4. 9.4.5 notes have two references to gin
> index but does not seem to address the issue.

> We are however able to create same index on some other databases. So it
> maybe data related or size of table related?

I'd guess that it's triggered by a specific data item or set of data
items. Doubt it has anything to do with table size per se. The quoted
value is 0x78000000, which makes me think that something is
misinterpreting a plain C string as a varlena value (with a length word),
or something along that line.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2015-10-16 13:48:34 Re: Allow ssl_renegotiation_limit in PG 9.5
Previous Message Shay Rojansky 2015-10-16 13:41:16 Re: Allow ssl_renegotiation_limit in PG 9.5